Export (0) Print
Expand All
Expand Minimize

How to create a DEFAULT object (Enterprise Manager)

SQL Server 2000

How to create a DEFAULT object (Enterprise Manager)

To create a DEFAULT object

  1. Expand a server group, and then expand a server.

  2. Expand Databases, and then expand the database in which to create the DEFAULT object.

  3. Right-click Defaults, and then click New Default.

  4. In Name, enter a name for the DEFAULT object.

  5. In Value, enter the value for the DEFAULT object. The value can be a constant or  expression.

  6. Optionally, click:
    • Bind UDTs to bind the new DEFAULT object to a user-defined data type.

    • Bind Columns to bind the DEFAULT object to an existing column in a table.

See Also

Creating and Modifying DEFAULT Definitions

© 2014 Microsoft