How to create user-defined data types (Enterprise Manager)

To create a user-defined data type

1. Expand a server group; then expand a server.
2. Expand Databases; then expand the database in which to create the user-defined data type.
3. Right-click User Defined Data Types; then click New User Defined Data Type....
4. Enter the name of the new data type.
5. In the Data type list, select the base data type.
6. 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.
7. To allow the data type to accept null values, select Allow NULLs.
8. Optionally, in the Rule and Default lists, select a rule or default, if any, to bind to the user-defined data type.

See Also