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.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.
In the left pane, double-click Domains.
In the right pane, right-click the domain and choose Delete.
Connect to the database as a user with DBA authority.
Execute a DROP DOMAIN statement.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|