How to create or delete a DEFAULT definition on a column of an existing table (Enterprise Manager)

To create or delete a DEFAULT definition on a column of an existing table

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database in which the table belongs, and then click Tables.
3. In the details pane, right-click the table, and then click Design Table.
4. In the Default value column, for each column name as appropriate, enter or delete the DEFAULT definition.

See Also

Creating and Modifying DEFAULT Definitions