Can in-memory tables be added to a database diagram

Question

I have a SQL Server 2016 database with in-memory tables. I'd like to use the database diagram feature to create a graphic to match.

Running SSMS 18.3.1. When I start a new diagram, the in-memory tables are not shown in the drop down. Is there another way to get them on the diagram?

Note: In the official documentation these are called memory-optimized tables. See Introduction to Memory-Optimized Tables

Answer 1

You can't add OLTP object in Database Diagram, not in even in SQL Server 2019.

I thought there should be a way to modify [definition] column in [dbo].[sysdiagrams] but it is HexString of unknown file type. (I tried many formats but its obviously an internal Microsoft type)

Unfortunately, there is no reference to mention that is a not-supported feature. (I send a comment to this page )

Answer 2

OLTP is not supported for database diagram. You do not have access to in-memory tables in the diagram because the diagram does not recognize the essence of a in-memory tables as a table, in fact SQL Server generates a DLL for each created Memory-Optimized Table Type that includes the functions required for accessing the indexes and retrieving data from the related Memory-Optimized Table Variable