How to check existence of user-define table type in SQL Server 2008?
Posted
by abatishchev
on Stack Overflow
See other posts from Stack Overflow
or by abatishchev
Published on 2010-03-22T19:32:03Z
Indexed on
2010/03/22
19:51 UTC
Read the original article
Hit count: 541
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
© Stack Overflow or respective owner