title: How to select from User Defined Table Type?
body: <pre><code>Select * from sys.table_types where user_type_id = TYPE_ID(N'dbo.udt_test');
  </code></pre>
  
  <p>The above query returns me data but when I try to query the data within, it says <code>dbo.udt_test</code> not exists?</p>
  
  <pre><code>Select * from dbo.udt_test
  </code></pre>
  
  <p><a href="https://msdn.microsoft.com/en-us/library/ms131086.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/ms131086.aspx</a></p>
  
  <p>Referred to the above link, there should be no problem with the select query to display data. May I know if I missing something obvious here?</p>