CODEWITHSUNDEEP
sql-serverforeign-keysin-memory-tables
ZedZip
ZedZip

Reputation: 6510

How to set Foreign Key constraint for 2 tables?

I have 2 tables in SQL Server 2016: Master->Detail. The Detail table I have migrated to Memory Optimized. But when I back set the Foreign Key constraint I receive the:

Msg 10778, Level 16, State 0, Line 32
Foreign key relationships between memory optimized tables and non-memory optimized tables are not supported.
Msg 1750, Level 16, State 1, Line 32
Could not create constraint or index. See previous errors.

How to connect again these Master (Disk) table and Detail (Memory Optimized) Table?

Upvotes: 0

Views: 216

Answers (0)

Related Questions