ASA SQL User's Guide
Ensuring Data Integrity
If data has integrity, the data is valid—correct and accurate—and the relational structure of the database is intact. Referential integrity constraints enforce the relational structure of the database. These rules maintain the consistency of data between tables.
Adaptive Server Anywhere supports stored procedures, which give you detailed control over how data enters the database. You can also create triggers, or customized stored procedures invoked automatically when a certain action, such as an update of a particular column, occurs.
For more information on procedures and triggers see Using Procedures, Triggers, and Batches.
How data can become invalid
Integrity constraints belong in the database
How database contents change
Data integrity tools
SQL statements for implementing integrity constraints