How to create user-defined data types (Enterprise Manager)
SQL Server 2000
To create a user-defined data type
- Expand a server group, and then expand a server.
- Expand Databases, and then expand the database in which to create the user-defined data type.
- Right-click User Defined Data Types, and then click New User Defined Data Type.
- Enter the name of the new data type.
- In the Data type list, select the base data type.
- If Length is active, enter another value if you want to change the maximum data length that the data type can store. The only data types that can have variable lengths are binary, char, nchar, nvarchar, varbinary, and varchar.
- To allow the data type to accept null values, select Allow Nulls.
- Optionally, in the Rule and Default lists, select a rule or default, if any, to bind to the user-defined data type.