This may work better as you don't need to run it for any given table SELECT OBJECT_NAME(c.object_id) ,
c.name ,
p.name ,
c.max_length
FROM sys.tables t
JOIN sys.columns c ON t.object_id = c.OBJECT_ID
JOIN sys.types p ON c.user_type_id = p.user_type_id
WHERE type = 'U'
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience