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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Working with UltraLite Databases

Deleting an existing UltraLite user Next Page

Viewing UltraLite database settings and modifying database options


You can only view configured database properties in Sybase Central. You cannot change them after the database is created. If you need to change a property, you need to create a new database and then load the data into it. You can, however, change database options at any time.

To browse UltraLite database properties (Sybase Central)
  1. Connect to the database.

  2. While browsing connected databases, right-click a database and select Properties.

    The Database Properties dialog appears.

  3. Select the Extended Information tab.

    Database properties are listed alphabetically by the property name. To sort database properties by the value, click the Value column.

  4. If you think database properties have changed since you started browsing them, click Refresh.

To browse or modify UltraLite database options (Sybase Central)
  1. Connect to the database.

  2. While browsing connected databases, right-click a database and select Options.

    The Database Options dialog box appears.

  3. If you want to set or reset an option, type a new value in the Value field.

  4. Click either Set Now or Reset Now to commit the change.

To modify database options (Interactive SQL)
  1. Connect to the UltraLite database.

  2. Execute a SET OPTION statement.

    Example    The following sets the global_database_id option to 100:

    SET OPTION global_database_id=100
  3. See also