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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Ensuring data integrity » Using domains

 

Create domains (SQL)

You can use the CREATE DOMAIN statement to create and define domains. See CREATE DOMAIN statement.

Some predefined domains are included with SQL Anywhere. For example, the monetary domain MONEY.

 To create a new domain (SQL)
  1. Connect to a database.

  2. Execute a CREATE DOMAIN statement.

 Example 1: Simple domains
 Example 2: Default values, check constraints, and identifiers