Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

How to: Create User-Defined Data Types (SQL Server Management Studio)

Use Object Explorer to create new user-defined data types.

  1. In Object Explorer, expand Databases, expand a database, expand Programmability, expand Types, right-click User-defined Data Types, and then click New User-defined Data Type.

  2. In the New User-defined Data Type dialog box, in the Schema box, type the schema to own this data type, or use the browse button to select the schema.

  3. In the Name box, type a name for the new data type.

  4. In the Data type box, select the data type that the new data type will be based on.

  5. Complete the Length, Precision, and Scale boxes if appropriate for that data type.

  6. Check Allow NULLs if the new data type can permit NULL values.

  7. In the Binding area, complete the Default or Rule boxes if you want to bind a default or rule to the new data type. Defaults and rules cannot be created in SQL Server Management Studio. Use Transact-SQL. Example code for creating defaults and rules are available in Template Explorer.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft