Visually Identify Memory Optimized Tables in SSMS

Question

I would and I believe the whole community would benefit from an SSMS feature whereby a Memory-Optimized table would be identified within the SSMS U/I in the exploded Database > Tables view. Maybe like "table_name (mo)" or some other way if identifying a table as being memory-optimized.

Answer 1

You can submit suggestions for enhancements in SQL Server and related products like SSMS at this site: https://feedback.azure.com/forums/908035-sql-server.

Answer 2

Hi @Rob Morrone ,

Thanks for your idea.
I recommend you to submit your issue to the Microsoft feedback at this link : https://feedback.azure.com/forums/908035-sql-server
This site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft feedback.

Currently the SSMS can not show the memory optimized tables directly as your idea, however, you can check your table whether it is one Memory Optimized Table as next:
--method1:SSMS

--method2:code

--show compatibility_level  
SELECT d.compatibility_level  
    FROM sys.databases as d  
    WHERE d.name = Db_Name();  
  
--list memory optimized table  
SELECT SCHEMA_NAME(Schema_id) SchemaName,  
name TableName,  
is_memory_optimized,  
durability_desc,  
create_date, modify_date  
FROM sys.tables  
GO  

More information: beginner-guide-to-in-memory-optimized-tables-in-sql-server

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

Hi @Rob Morrone ,

Is the reply helpful?

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 4

No, MiaMiao-MSFT. It wasn't helpful. These are obviously the way to determine the MO status of a table. But they're not visible from SSMS U/I. That was my original ask, that it be visible from Object Explorer folder view.

Something like Backups (MO).