User define type

Transact-SQL
1

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

2

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

3

You can look in sys.types or use TYPE_ID
You should go this one it may be helpful to you https://sqltimes.wordpress.com/2014/05/10/sql-server-how-to-check-if-a-user-define-table-type-exists-using-query-tsql/

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