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, 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