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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database file types » Database creation


Constraint considerations

Although the data type of a column restricts the values that are allowed in that column (for example, only numbers or dates), you may want to further restrict the allowed values.

You can restrict the values of any column by specifying a CHECK constraint. A CHECK constraint is a restriction that enforces specified conditions on a column or set of columns. You can use any valid condition that could appear in a WHERE clause to restrict the allowed values. Most CHECK constraints use either the BETWEEN or IN condition.

 See also