CODEWITHSUNDEEP
c#sql-serversql-server-2016oltpin-memory-oltp
Learner
Learner

Reputation: 1315

In Memory OLTP table is not visible in SQL Server 2016 Management Studio object explorer

I'm using SQL Server 2016 to learn about in-memory OLTP tables.

I created a database mydatabase and then run alter commands on this to create a file group:

ALTER DATABASE mydatabase 
    ADD FILEGROUP [mydatabase_mod] CONTAINS MEMORY_OPTIMIZED_DATA;

To create a container on this group:-

ALTER DATABASE mydatabase 
    ADD FILE (name = [mydatabase_dir], filename= 'e:\Learn\mydatabase_dir')  
        TO FILEGROUP mydatabase_mod;

These commands executed successfully, and then I created memory optimized durable and non durable tables in this database; mytable_durable and mytable_non_durable are created successfully.

CREATE TABLE [dbo].[mytable_durable] 
( 
    c1 INT NOT NULL PRIMARY KEY NONCLUSTERED HASH WITH (BUCKET_COUNT=1000000),  
    c2 NCHAR(48) NOT NULL  
) WITH (MEMORY_OPTIMIZED=ON, DURABILITY = SCHEMA_AND_DATA);  

CREATE TABLE [dbo].[mytable_non_durable] 
(  
    c1 INT NOT NULL PRIMARY KEY NONCLUSTERED HASH WITH   (BUCKET_COUNT=1000000),  
    c2 NCHAR(48) NOT NULL  
) WITH (MEMORY_OPTIMIZED=ON, DURABILITY = SCHEMA_ONLY);

Now I want to see these two tables in object explorer in SQL Server 2016. They are not visible in my database under mydatabase > Tables node. How can I see them? Please see the attached screenshot.

enter image description here

But if I run this 

SELECT 
    name, object_id, type_desc, durability_desc, 
    temporal_type, temporal_type_desc
FROM 
    sys.Tables

I can see both tables. Please see following screenshot.

enter image description here

Is there any way where I can see them in object explorer?. Or is this default behaviour?

Upvotes: 1

Views: 334

Answers (2)

Saftpresse99
Saftpresse99

Reputation: 979

I had the same problem. The solution was to make sure to open the correct SSMS version. I installed version 17.1 from here: https://learn.microsoft.com/en-us/sql/ssms/sql-server-management-studio-changelog-ssms and run C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe

Upvotes: 1

user3589422
user3589422

Reputation:

Ok. I see the issue here is the version you are using. You are using SSMS 16.3

Please make sure you use the latest version of SSMS. Current version is 16.5.3 as of this writing. Download it here. Please take note that Microsoft is doing a monthly patch/updates of SSMS.

Upvotes: 0

Related Questions