SQL Server 2016 CTP 3.0 was just announced this morning. With it brings some much needed database object support for In Memory tables:
In-Memory OLTP
- FOREIGN KEY constraints
- CHECK constraints
- UNIQUE constraints
- DML triggers (AFTER only)
- EXECUTE AS CALLER
- Inline table-values functions
- Security built-ins and increased math function support
This is a much needed improvement for In-Memory. Read more about SQL 2016 CTP 3 here:
http://blogs.technet.com/b/dataplatforminsider/archive/2015/10/28/sql-server-2016-community-technology-preview-3-0-is-available.aspx