Progress
Embedded SQL-92
Guide and Reference


Integrity Constraints

Integrity constraints are application rules that the database enforces. You define integrity constraints on base tables to ensure data integrity in a database. An integrity constraint can specify unique values for a column, validate values of a column, or provide referential integrity.

Referential integrity ensures that the relationships among different rows of the same or different tables are valid. For example, you might use referential integrity to ensure that a master row is inserted before a detail row, and a detail row is deleted before a master row.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095