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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Ensuring Data Integrity » Using domains

Creating domains (SQL) Next Page

Dropping domains

You can use either Sybase Central or a DROP DOMAIN statement to drop a domain.

Only a user with DBA authority or the user who created a domain can drop it. In addition, since a domain cannot be dropped if any variable or column in the database uses the domain, you need to first drop any columns or variables of that type before you can drop the domain.

To drop a domain (Sybase Central)
  1. Open the Domains folder.

  2. Click the desired domain and choose Edit > Delete.

  3. To drop a domain (SQL)
    1. Connect to a database.

    2. Execute a DROP DOMAIN statement.

    3. Example

      The following statement drops the persons_name domain.

      DROP DOMAIN persons_name;

      For more information, see DROP statement.