What are database constraints?
Can you give examples?
Database Constraints are rules applied to ensure the integrity and accuracy of the data
within a database. Examples include:
- NOT NULL: Ensures that a column cannot have a NULL value.
- UNIQUE: Ensures all values in a column are unique.
- CHECK: Ensures that all values in a column satisfy a specific condition.
- DEFAULT: Sets a default value for a column if no value is specified.
- FOREIGN KEY: Ensures the value in one table corresponds to a valid value in
another table.