Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Designing and Creating Databases » Ensuring data integrity » Introduction to data integrity

 

SQL statements for implementing integrity constraints

The following SQL statements implement integrity constraints:

  • CREATE TABLE statement   This statement implements integrity constraints during creation of the table.

  • ALTER TABLE statement   This statement adds integrity constraints to an existing table, or modifies constraints for an existing table.

  • CREATE TRIGGER statement   This statement creates triggers that enforce more complex business rules.

  • CREATE DOMAIN statement   This statement creates a user-defined data type. The definition of the data type can include constraints.

For more information about the syntax of these statements, see SQL statements.