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.
In Sybase Central, open the folder in which the object resides.
Select the object. The object's properties appear in the right pane of Sybase Central.
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.