Mid SQL

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.

More from SQL Server Tutorial

All questions for this course