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 - SQL Usage » Working with Database Objects » Working with databases

Connecting to a database Next Page

Setting properties for database objects

Most database objects (including the database itself) have properties that you can either view or set. Some properties are non-configurable and reflect the settings chosen when you created the database or object. Other properties are configurable.

The best way to view and set properties is to use the property sheets in Sybase Central.

If you are not using Sybase Central, properties can be specified when you create the object with a CREATE statement. If the object already exists, you can modify options with an ALTER statement.

To view and edit the properties of a database object (Sybase Central)
  1. In Sybase Central, open the folder in which the object resides.

  2. Select the object. The object's properties appear in the right pane of Sybase Central.

  3. In the right pane, click the appropriate tabs to edit the desired properties.

    You can also view and edit properties on the object's property sheet. To view the property sheet, select the object and then choose File > Properties.