You can delete a dbspace using either Sybase Central or the DROP DBSPACE statement. Before you can delete a dbspace, you must delete all tables and indexes that use the dbspace. You must have DBA authority to delete a dbspace.

♦  To delete a dbspace (Sybase Central)

1. Open the Dbspaces folder.

2. Right-click the dbspace and choose Delete.

♦  To delete a dbspace (SQL)

1. Connect to a database.

2. Execute a DROP DBSPACE statement.

See also

• Drop tables
• DROP DBSPACE statement