|
User Defined Datatypes
User Defined Datatypes are datatypes defined by the user to enhance the existing system datatypes.
User defined datatypes can be created using the command:
sp_addtype.
Use
sp_droptype
to delete a user defined datatype.
A list of all user defined datatypes can be retrieved using the command
sp_help "type_name".
It is more elegant though, to display information on user defined datatypes in the current
database by querying the
system table
systypes:
SELECT name
FROM systypes
WHERE usertype > 90
|
