CODEWITHSUNDEEP
sql-server-2016
Praveen with 9 Yrs Experience
Praveen with 9 Yrs Experience

Reputation: 29

In SQL Server 2016,If we create Memory Optimized Table

In SQL Server 2016,If we create Memory Optimized Table(i.e create table on RAM ),will the table data persist if I restart my computer?

Upvotes: 0

Views: 579

Answers (1)

Niels Berglund
Niels Berglund

Reputation: 1698

When you create a memory optimized table you set a table option: WITH (MEMORY_OPTIMIZED = ON). That table option has a second parameter DURABILITY which either can be: SCHEMA_AND_DATA in which case the data is persisted, or SCHEMA_ONLY in which case only the schema is persisted. Default is SCHEMA_AND_DATA.

You can read more about it here.

Niels

Upvotes: 1

Related Questions