Browse by Tags

All Tags » image » lob   (RSS)
How do I find the data types such as xml or text or image of a specified table?
18 July 07 07:34 AM | SQL Master | 1 Comments   
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=OBJECT_ID('<schema_name.table_name>') Read More...
Filed under: , , , , ,