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 - SQL Usage » Data integrity » Domains

 

Applying a domain to a column

In Sybase Central, you can change a column to use a domain (user-defined data type).

Prérequis

You must be the owner of the table the column belongs to, or have one of the following privileges:

  • ALTER privilege on the table
  • ALTER ANY TABLE system privilege
  • ALTER ANY OBJECT system privilege
 Task

  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, double-click Tables.

  3. Click the table.

  4. In the right pane, click the Columns tab.

  5. Right-click a column and click Properties.

  6. Click the Data Type tab and click Domain.

  7. In the Domain list, select a domain.

  8. Click OK.

Résultat

The column uses the selected domain.

 See also
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0