User define type

Transact-SQL
4

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