title: 'MEMORY_OPTIMIZED' is not a recognized CREATE TYPE option
body: <p>I'm experimenting with <a href="https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/faster-temp-table-and-table-variable-by-using-memory-optimization" rel="nofollow noreferrer">memory-optimized user-defined table types</a> (§D.2 and §E) on SQL Server 2016.</p>
  
  <p>Context:</p>
  
  <ul>
  <li>SQL Server Enterprise 13.0.4446.0 (that's CU4, released August 8, 2017)</li>
  <li>Database restored from a SQL Server 2008 R2 instance</li>
  <li>Database's <code>COMPATIBILITY_LEVEL</code> set to 130 (SQL Server 2016)</li>
  <li>Created a memory optimized filegroup for database</li>
  </ul>
  
  <p>And yet:</p>
  
  <pre><code>create type dbo.test_type as table(
  id int not null,
  primary key clustered (id asc) 
      with (ignore_dup_key = off, memory_optimized = on))
  </code></pre>
  
  <p>fails with output:</p>
  
  <blockquote>
    <p>Msg 155, Level 15, State 1, Line 4 'memory_optimized' is not a
    recognized CREATE TYPE option.</p>
  </blockquote>
  
  <p>What am I missing?</p>