ASA Database Administration Guide
  Working with Database Files
    Using additional dbspaces

Deleting a dbspace

You can delete a dbspace using either Sybase Central or Interactive SQL. Before you can delete a space, you must delete all tables that use the space. You must have DBA authority to delete a dbspace.

To delete a dbspace (Sybase Central)

1. Open the Dbspaces folder.

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

To delete a dbspace (SQL)

1. Connect to a database.

2. Execute a DROP DBSPACE statement.

See also

• Deleting tables

• DROP statement