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

To delete a user-defined data type

1. Expand a server group; then expand a server.
2. Expand Databases, expand the database, and then click User Defined Data Types.
3. In the details pane, right-click the data type to delete, and then click Delete.
4. To see how deleting this data type will affect the database, click Show Dependencies....
5. In the Drop Objects dialog box, click Drop All.

See Also