3

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_IntListType_2E4CAB33
xtype : TT
type : TT

and stuff.

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

Andriy M
  • 76,112
  • 17
  • 94
  • 154
Bas Hamer
  • 33
  • 2

2 Answers2

1

Query sys.table_types instead.

Martin Smith
  • 438,706
  • 87
  • 741
  • 845
0

Check out the sys.types table.

select * from sys.types
 where name like '%listtype%'
Scott Ferguson
  • 7,690
  • 7
  • 41
  • 64