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