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.
- Under the
Defaults folder, find the default you want to
edit.
- Right-click the
default, and choose
Edit.
The Default Editor page opens.
- 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. |
- View the DDL for
the default in the
DDL tab.
- 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.
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.