开发者

retrieving the name of a user created table type programatically

开发者 https://www.devze.com 2023-03-27 10:58 出处:网络
Running a select on sys.objects for a type I created: CREATE TYPE [dbo].[IntListType] AS TABLE( [ID] [int] NULL)

Running a select on sys.objects for a type I created:

CREATE TYPE [dbo].[IntListType] AS TABLE(
[ID] [int] NULL) 


Select * From sysObjects Where Name Like '%listtype%'

I get the names back as follows:

name : TT_IntL开发者_开发知识库istType_2E4CAB33
xtype : TT
type : TT 

and stuff.

How do I get the access to the original name of dbo.IntListType?


Query sys.table_types instead.


Check out the sys.types table.

select * from sys.types
 where name like '%listtype%'
0

精彩评论

暂无评论...
验证码 换一张
取 消