title: How to check existence of user-define table type in SQL Server 2008?
body: <p>I have a user-defined table type. I want to check it's existence before editing in a patch using <code>OBJECT_ID(name, type)</code> function.</p>
  
  <p>What <code>type</code> from the <a href="http://msdn.microsoft.com/en-us/library/ms190324.aspx" rel="noreferrer">enumeration</a> should be passed for user-defined table types?</p>
  
  <p><code>N'U'</code> like for user defined table doesn't work, i.e. <code>IF OBJECT_ID(N'MyType', N'U') IS NOT NULL</code></p>