Specify a value to insert in a column if no value is explicitly
supplied at insert time.
- In the left pane of the Administration Console, expand , then select Defaults.
- Click the drop-down arrow and select New.
- On the Introduction screen, select the server, database, and owner of the new default.
- Enter the name of the default.
- Enter the expression to define the value of the default. Expressions must be constants, mathematical expressions, or built-in functions.
- (Optional) Click Summary to verify your selected options.