Dbspace Properties window: General tab

This tab has the following components:

  • Name   Shows the name of the dbspace.

  • Type   Shows the type of object.

  • File   Shows the name of the database file that the dbspace points to.

    Specifying a new file name or file location in this field updates only the catalog; it does not create the file or change the file's name or location. You must ensure that the dbspace file can be found by SQL Anywhere. Changing the file name in this field is equivalent to running the ALTER DBSPACE statement with the RENAME clause. You can not change the file name for the system or the temporary dbspaces.

  • Pre-allocate Space Now   Displays the Pre-allocate Space for Dbspace window, which lets you pre-allocate storage in the dbspace by adding pages to it. Adding pages may improve performance for bulk-loading operations.

 See also