ASA SQL User's Guide
  Ensuring Data Integrity
    Using domains

Deleting domains

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

Only the user DBA 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 is an instance of the domain, you need to first drop any columns or variables of that type before you can drop the domain.

To delete a domain (Sybase Central)

1. Open the Domains folder.

2. Right-click the desired domain and choose Delete from the popup menu.

To delete a domain (SQL)

1. Connect to a database.

2. Execute a DROP DOMAIN statement.

Example 

The following statement drops the customer_name domain.

DROP DOMAIN customer_name

For more information, see DROP statement.