将sys.types加入sys.parameters(Join sys.types to sys.parameters)

将加入sys.parameters(Join to sys.parameters)

我想在用户定义的表中列出列。

SELECT * FROM t WHERE t.is_user_defined = 1 AD t.is_table_type = 1

如何将加入sys.parameters以便我可以获得所需的信息？

以下是我将如何定义用户定义的表：

CREATE TYPE MyTable AS TABLE ( Id UIQUEIDETIFIER , ame VARCHAR )

我想要的输出是

TableType | Parameter | ParameterID ----------------------------------- MyTable | Id | 0 MyTable | ame | 1

I would like to list columns in a user defined table.

SELECT * FROM t WHERE t.is_user_defined = 1 AD t.is_table_type = 1

How do I join to sys.parameters so I can get the information I need?

Here is how I would define the user defined table:

CREATE TYPE MyTable AS TABLE ( Id UIQUEIDETIFIER , ame VARCHAR )

My desired output would be

TableType | Parameter | ParameterID ----------------------------------- MyTable | Id | 0 MyTable | ame | 1

最满意答案

我想这就是你要的东西

SELECT , , _id FROM _Types t JOI c O _table_object_id = _id WHERE t.is_user_defined = 1 AD t.is_table_type = 1

I think this is what you are looking for

SELECT , , _id FROM _Types t JOI c O _table_object_id = _id WHERE t.is_user_defined = 1 AD t.is_table_type = 1