Delete 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. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. Open the Dbspaces folder.

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