How to create a DEFAULT object (Enterprise Manager)

To create a DEFAULT object

1. Expand a server group; then expand a server.
2. Expand Databases; then expand the database in which to create the DEFAULT object.
3. Right-click Defaults; 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, expression, or variable.
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