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

How to Install SQL Server 2000

How To

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

To delete a user-defined data type

  1. Expand a server group, and 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

Creating User-defined Data Types

sp_droptype

Using Data Types