User define type

Is there any stored procedure like Sp_helptext or quey to retrive to find User defined type table ?

I don't know if there is a system stored proc, but you can query the system view sys.types

SELECT * FROM sys.types WHERE is_user_defined = 1

You can look in sys.types or use TYPE_ID
You should go this one it may be helpful to you

thanks for you replyJames k,Jason_clark.

But I am looking for a solution like if we get definition of an Sp mysp using exec Sp_helptext 'mysp'.
I need definition of that type