Browse by Tags

All Tags » tsql » datatype » xml (RSS)
How do I find the data types such as xml or text or image of a specified table?
Published 18 July 7 9:34 AM | SSQA.net
USE <database_name>; GO SELECT name AS column_name ,column_id ,TYPE_NAME(user_type_id) AS type_name ,max_length ,CASE WHEN max_length = -1 AND TYPE_NAME(user_type_id) <> 'xml' THEN 1 ELSE 0 END AS [(max)] FROM sys.columns WHERE object_id...
Filed under: , , , , ,