Setting properties for database objects

Most database objects, including the database itself, have properties that you can either view or set. Some properties that reflect settings that were chosen when you created the database are non-configurable.

The best way to view and set properties is to use the properties windows 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 properties 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 properties.

    You can also view and edit properties on the object's properties window. To view the properties window, right-click the object, and then choose Properties.

See also