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%'
精彩评论