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 » Database Options » Introduction to database options » Alphabetical list of options

dedicated_task option [database] Next Page

default_dbspace option [database]

Changes the default dbspace in which tables are created.

Allowed values



Empty string


Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.


For each database, you can create up to twelve dbspaces in addition to the system (main) dbspace. When a table is created without specifying a dbspace, the dbspace named by this option setting is used. If this option is not set, is set to the empty string, or is set to system, then the system dbspace is used.

If all tables are created in a location other than the system dbspace, then the system dbspace is only used for the checkpoint log and system tables. This is useful if you want to put the checkpoint log on a separate disk from the rest of your database objects for performance reasons. You can place the checkpoint log in a separate disk by changing all CREATE TABLE statements to specify the dbspace, or by changing this option before creating any tables.

See also

In the following example, a new dbspace named library is created. The default dbspace is then set to the library dbspace and the table LibraryBooks is stored in the library dbspace instead of the system dbspace.

AS 'e:\\dbfiles\\library.db';
SET OPTION default_dbspace = 'library';
CREATE TABLE LibraryBooks (
  title CHAR(100),
  author CHAR(50),
  isbn CHAR(30),