SQLTeam.com | Weblogs | Forums

User define type


#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