SQL-92 Create Table Constraints
PRIMARY KEY
rejects duplicates and nulls
UNIQUE
rejects duplicates, allows nulls
DEFAULT
inserts the default value when no value is entered
CHECK
validates data format
FOREIGN KEY and REFERENCES
ties foreign key to the primary key it references
Previous slide
Next slide
Back to first slide
View graphic version