Editing a Default

Edit a database default to change the default value specified to insert in a column (or in all columns of a user-defined datatype) if no value is explicitly supplied at insert time.

Prerequisites 

Before you can edit a default, be sure that the data server that contains the default is running and that you created and established a connection to the data server.

  1. Under the Defaults folder, find the default you want to edit.
  2. Right-click the default, and choose Edit.

    The Default Editor page opens.

  3. In the General tab, provide values for the following fields.
    Table 1. General options
    Field Description
    Name Specify a name for the default in the corresponding text field.
    Default Expression A read-only field that displays the default constant expression.
  4. View the DDL for the default in the DDL tab.
  5. When you finish editing the default, close the Default Editor page, and save your results.
Sybase WorkSpace executes the DDL to change the default and reports results to the console.
Related tasks
Creating a Default
Dropping a Default
Renaming a Default

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.