SQL Constraints

Constraints are used to limit the type of data that can go into a table.

Constraints can be specified when a table is created (with the CREATE TABLE statement) or after the table is created (with the ALTER TABLE statement).
We will focus on the following constraints:

• NOT NULL
• UNIQUE
• PRIMARY KEY
• FOREIGN KEY
• CHECK
• DEFAULT

The next chapters will describe each constraint in details.

If you like this please Link Back to this article...

<a href="http://learning-tutorial.blogspot.com/2010/11/sql-constraints.html">SQL Constraints</a>