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. 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

The following statement drops the persons_name domain.

DROP DOMAIN persons_name;

For more information, see DROP statement.