Dropping User-defined Datatypes

You remove user-defined datatypes from a database by dropping them.

    To drop a user-defined datatype

• From the Manage menu in SQL Enterprise Manager, choose User-Defined Datatypes, select the datatype you want to drop, and then click the Drop button.

  (For details, search for "user defined datatypes" in SQL Enterprise Manager Help.)

Or

• Execute the sp_droptype system stored procedure.

  For example:

  sp_droptype ssn
  

  drops the ssn (social security number) datatype created in the preceding example.

  (For details, see the sp_droptype system stored procedure in the Microsoft SQL Server Transact-SQL Reference.)

Note You cannot drop a user-defined datatype if it is used within a table definition or if a rule or default is bound to it.