Setting Database Options

Adjust the configurable settings of a database to change the way the database behaves or performs.

Prerequisites
Authenticate with Sybase IQ using an account that has DBA authority.
Task
  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the left pane of the Administration Console, select Schema Objects > Databases.
  3. Select the database from the right pane and either:
    • Click the drop-down arrow to the right of the name and select Options, or,
    • From the Administration Console menu bar, select Resource > Options.
  4. In the Setting column, change a database option value and click Apply.
Parent topic: Manage a Database
Related tasks
Viewing Database Properties
Creating a Database