() — thirdparty Sybase/SQL_Server

  1                       Version 4.0 -- 1/15/89             sp_droptype
  ______________________________________________________________________

  NAME:  sp_droptype

  FUNCTION:
       Drops a user-defined datatype by deleting the type from systypes.

  SYNTAX:
       sp_droptype typename

  EXAMPLES:
       sp_droptype birthday

       Drops the user-defined datatype named birthday.







  sp_droptype             Version 4.0 -- 1/15/89                       2
  ______________________________________________________________________

  PARAMETERS:
       typename -  is the name of a user-defined datatype that you own.

  COMMENTS:

       o Executing sp_droptype deletes a user-defined datatype from sys-
         types.
       o A user datatype cannot be dropped if tables or  other  database
         objects reference it.

  MESSAGES:
       The user-defined type no longer exists in the current database.
       You do not own a user datatype with that name.
       A user datatype referenced by a table or  other  database  object
           cannot be dropped.  Drop the tables and/or procedures first.




  3                       Version 4.0 -- 1/15/89             sp_droptype
  ______________________________________________________________________

  PERMISSIONS:
       Execute permission to Database Owner and datatype owner.

  TABLES USED:
       syscolumns, sysobjects, systypes, sysusers

  SEE ALSO:
       sp_addtype, sp_rename
Museum
