SQL Anywhere® Server - Database Administration  > Working with Database Files  > Using additional dbspaces

Deleting a dbspace

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

• Dropping tables
• DROP statement

---