Here, I have taken example for XML Data type:
- SELECT T.NAME AS [TABLE NAME], C.NAME AS [COLUMN NAME], P.NAME AS [DATA TYPE], P.MAX_LENGTH AS[SIZE], CAST(P.PRECISION AS VARCHAR) +'/'+ CAST(P.SCALE AS VARCHAR) AS [PRECISION/SCALE]
-
- FROM SYS.OBJECTS AS T
-
- JOIN SYS.COLUMNS AS C
-
- ON T.OBJECT_ID=C.OBJECT_ID
-
- JOIN SYS.TYPES AS P
-
- ON C.SYSTEM_TYPE_ID=P.SYSTEM_TYPE_ID
-
- WHERE T.TYPE_DESC='USER_TABLE' and P.name='xml'