SQL CONSTRAINTS
Constraints are used to specify rules for data that can go into a table.
Constraints can be both column level and table level, which ensures the accuracy and authenticity of the data in the database.
The following constraints are commonly used in SQL:
-
NOT NULL - Checks that a column cannot have a NULL value
-
UNIQUE - Checks that all values in a column are unique or different from one another
-
PRIMARY KEY - A combination of a NOT NULL and UNIQUE. Uniquely identifies each row in a table. We can define only one Primary key in the table.
-
FOREIGN KEY - Uniquely identifies a row/record in another table.
-
CHECK - Checks that all values in a column satisfies a specific condition
-
DEFAULT - Sets a default value for a column when no value is specified.
INDEX – We can create Index on any table and retrieve data from the database very quickly.
Want More SQL Deep Dives