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