Pages

Wednesday, August 27, 2014

How to find the definition of a User-Defined Table Type


SELECT c.name, st.name, c.is_nullable, c.max_length, c.precision, c.scale
       FROM sys.columns c INNER JOIN sys.table_types tt
                          ON c.object_id = tt.type_table_object_id
                          INNER JOIN sys.types st
                          ON c.system_type_id = st.system_type_id
       WHERE tt.name = '{Insert Type Name Here}';


No comments:

Post a Comment