Memory-optimized tables and natively compiled stored procedures cannot be created or dropped if there is a server or database event notification for that DDL operation. Remove the server and database event notifications on CREATE TABLE or DROP TABLE and CREATE PROCEDURE or DROP PROCEDURE.
What happens if you attempt to do it?
Msg 10794, Level 16, State 124, Line 1
The feature 'EVENT NOTIFICATION' is not supported with memory optimized tables.
Why is this a big deal? Because, honestly, I'm scared that if they're not supporting things like this, that EN is on its way out. I use it extensively (see my presentations on it, coming soon to a SQL Saturday near you), and it's IMHO a must-have feature. It also means that whenever we want to do something with Hekaton, we have to drop the EN, do the Hekaton-based changes, then we're less likely to use Hekaton or EN.
Please vote on my Connect item: