How to create a DEFAULT definition on a column when creating a table (Enterprise Manager)

To create a DEFAULT definition on a column when creating a table

1. Expand a server group; then expand a server.
2. Expand Databases; then expand the database in which to create the table.
3. Right-click Tables; then click New Table....
4. In the Choose Name dialog box, enter a name for the table.
5. Fill in the columns as appropriate. Each row represents one column in the table.
6. In the Default value column, for each column name as appropriate, enter the DEFAULT definition.

See Also

Creating and Modifying DEFAULT Definitions