How to check existence of user-define table type in SQL Server 2008?

I have a user-defined table type. I want to check it’s existence before editing in a patch using OBJECT_ID(name, type) function.

What type from the enumeration should be passed for user-defined table types?

N'U' like for user defined table doesn’t work, i.e. IF OBJECT_ID(N'MyType', N'U') IS NOT NULL

5 Answers
5

Leave a Comment