要清楚我正在寻找实际的表类型定义:
例如我想获取myTableType的列定义
CREATE TYPE myTableType AS TABLE( Id INT,SomeValue NVARCHAR(20) );
SELECT * FROM sys.columns WHERE object_id IN ( SELECT type_table_object_id FROM sys.table_types WHERE name = 'some_table_type' );