Computer Science
Answer
Database constraints enforce business rules on a database. These include PRIMARY KEY for unique identifiers, FOREIGN KEY for maintaining relationships between tables, UNIQUE for ensuring uniqueness, CHECK constraint limit values that can be inserted into a column of a table, and default constraints are utilized to specify a default value for a column when no value is explicitly provided during an insert operation.
Related Questions
How is FOREIGN KEY commands different from PRIMARY KEY command ?
How is FOREIGN KEY commands related to the PRIMARY KEY ?
What are table constraints ? What are column constraints ? How are these two different ?
What is default value ? How do you define it ? What is the default value of column for which no default value is define ?