• 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