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 https://sqltimes.wordpress.com/2014/05/10/sql-server-how-to-check-if-a-user-define-table-type-exists-using-query-tsql/
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