SQLTeam.com | Weblogs | Forums

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