User Datatypes Wizard (SQL Server)
Go Up to Microsoft SQL Server Object Wizards
User datatypes promote domain consistency by streamlining the definition of commonly used table columns in a database. You can build a customized datatype from system datatypes and bind defaults and rules to it to enhance integrity. When you reference the user datatype in a column, the column assumes all of the properties of the user datatype.
To create a new user datatype using a wizard:
- Open a creation wizard for a user datatype. 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 - User Datatypes (SQL Server) - Properties.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
User Datatypes (SQL Server) - Properties
When creating or editing a user datatype, this tab/panel lets you work with the following settings:
Setting | Description |
---|---|
Owner |
Select the owner of the user datatype. |
Datatype |
Provide a name for the datatype. |
Type |
Select the base datatype. |
Size |
Provide the size of the datatype. |
Allow Nulls |
Null has no explicitly assigned value. Null is not equivalent to zero or blank. A value of null is not considered to be greater than, less than, or equivalent to any other value, including another value of null. |
Default Binding |
Defaults promote data integrity by supplying a default value to a column if the user does not explicitly provide one. They are reusable objects that you can bind to user datatypes. |
Rule Binding |
Rules promote data integrity by allowing you to validate the values supplied to a column. They are reusable objects that you can bind to user datatypes. |