Constraint
Constraints are used to limit the type of data that can go into a database table. This ensures the accuracy and reliability of the data in a table.
Common constraints:
Constraint
Value
UNIQUE
Ensures that all values in a column are unique.
FOREIGN KEY
Uniquely identifies a row/record in another table.
CHECK
Ensures that all values in a column satisfy a specific condition.