Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Working with Database Files » Using additional dbspaces

Pre-allocating space for database files Next Page

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.

  3. To delete a dbspace (SQL)
    1. Connect to a database.

    2. Execute a DROP DBSPACE statement.

    3. See also