retrieving the name of a user created table type programatically

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%'