How to delete user-defined data types (Enterprise Manager)
SQL Server 2000
To delete a user-defined data type
- Expand a server group, and then expand a server.
- Expand Databases, expand the database, and then click User Defined Data Types.
- In the details pane, right-click the data type to delete, and then click Delete.
- To see how deleting this data type will affect the database, click Show Dependencies.
- In the Drop Objects dialog box, click Drop All.