Showing posts with label SQL Constraints. Show all posts
Showing posts with label SQL Constraints. Show all posts

Tuesday, 19 July 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.
Related Posts Plugin for WordPress, Blogger...