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.
-
In the Databases folder in Enterprise Explorer, under the database connection profile,
expand the Databases folder, and then expand the tree for a database
and then the tree for the appropriate schema owner.
-
Under the
Defaults folder, find the default you want to
edit.
-
Right-click the
default, and choose
Edit.
-
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. |
-
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.