ASA SQL User's Guide
  Working with Database Objects
    Working with databases

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 a SET OPTION statement.

To view and edit the properties of a database object (Sybase Central)

1. In the left pane of 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, right-click the object and choose Properties from the popup menu.