Saturday, July 30, 2005

User Defined Datatypes

To list all the User Defined Datatypes in a given database:

SELECT
[name] UDT,
type_name(xtype) Type,
Length,
xprec [Precision],
xscale Scale,
CASE WHEN AllowNulls = 1 THEN 'Yes' ELSE 'No' END [ISNULL]
FROM systypes
WHERE xusertype > 256
ORDER BY [name]

posted by Chandra Ananthapatnayakuni @ 7/30/2005 04:58:00 AM

0 Comments:

Post a Comment

<< Home