Reputation: 1367
It is possible to figure out the table definition of the user defined tabled-type?
There is no column in sys.types with such info. And sys.modules does not contains info about types.
Upvotes: 0
Views: 51
Reputation: 28403
Try this
SELECT *
FROM sys.columns
WHERE object_id IN (
SELECT type_table_object_id
FROM sys.table_types
WHERE name = 'some_table_type'
);
Upvotes: 1