Enforce Data Integrity

Table and column constraints and appropriate data type selection ensure that the data in your database is valid and reliable.

• Data Integrity Overview
  For data to have integrity means that the data is valid—that is, correct and accurate—and that the relational structure of the database is intact.
• Column Defaults Encourage Data Integrity
  Column defaults automatically assign a specific value to a particular column or set of columns whenever a new row is entered into a database table.
• Table and Column Constraints
  Constraints help to ensure that the data entered into a table is correct, and provide information to SAP Sybase IQ that boosts performance.
• Entity and Referential Integrity
  Once you specify the primary key for each table, no further action is needed by client application developers or the database administrator to maintain entity integrity.
• Integrity Rules in System Tables
  All the information about integrity checks and rules in a database is held in system tables and views.
• Validating Catalog Store Indexes
  You can validate an index on SQL Anywhere tables in the catalog store to ensure that every row referenced in the index actually works in the table.