Drop a database default to omit a default value specified to
insert in table columns.
PrerequisitesÂ
Before you can drop a default, be sure the data server on which you are dropping the default is running,
and 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.
-
Expand the
Defaults folder, right-click the
default, and choose
Drop.