The key is to keep company only with people who uplift you, whose presence calls forth your best.

Tuesday, 11 October 2011

SQL Constraints

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 detail.



0 comments:

Post a Comment