Defaults Wizard (SQL Server)
Go Up to Microsoft SQL Server Object Wizards
When bound to a column or user-defined object, a default ensures that a specific value will be inserted into the column where the object will be bound if no explicit value is given.
The Default Wizard lets you name the default and specify its value.
To create a new default using a wizard:
- Open a creation wizard for a default. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - Defaults (SQL Server) - Properties.
- Dependencies panel - Defaults (SQL Server) - Dependencies.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
Defaults (SQL Server) - Properties
When creating or editing a default, this tab/panel lets you work with the following settings:
| Setting | Description |
|---|---|
|
Schema |
Select the schema that is to own the default. |
|
Name |
Provide a name for the default. |
|
Value |
Provide the value of the default. |
Defaults (SQL Server) - Dependencies
From the Type dropdown, choose Column or Datatype, and if you chose Column, choose a Table from the Table dropdown. The list on the left is populated with candidate columns or datatypes. To move a candidate from the list on the left to the dependencies column on the right, select the candidate and click Add. Remove columns or datatypes from the dependencies list on the right by selecting the column or datatype and clicking Remove.