Drop 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. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

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

  3. In the right pane, right-click the domain and choose Delete.

  4. Click Yes.

 To drop a domain (SQL)

  1. Connect to the database as a user with DBA authority.

  2. Execute a DROP DOMAIN statement.

 Example
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0