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.
  3. Change the name of the default.
    Table 1. General tab options
    Field Description
    Name Specify a name for the default.
    Default Expression 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

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com