In-Memory Optimized Tables - Getting Started with SQL Server 2014 Administration - page 35

• Bigint
• Money
• Smallmoney
• Float
• Real
• Datetime
• Smalldatetime
• Datetime2
• Date
• Time
• Numeric
• Decimal Types
• All non-LOB string types: char(n), varchar(n), nchar(n), nvarchar(n), sysname
• Non-LOB binary types: binary(n), varbinary(n)
• Uniqueidentifier
There can be no data types for XML, CLR, or MAX—LOB
data types are not allowed.
There are several other limitations to consider when using memory-optimized tables
given as follows:
• No FOREIGN KEY or CHECK constraints
• No UNIQUE indexes other than for the PRIMARY KEY
• No IDENTITY columns
• No DML triggers
• Maximum of eight indexes
• No schema changes when the table has been created
• No ALTER table, instead you would drop and recreate the table to make a
change to its schema
• CREATE ALTER AND DROP indexes won't work either; the indexes get
created as part of the create table statement
• Row lengths are limited to 8060 bytes, which get enforced during
table creation