Sep 26, 2013

Script to get the list of all memory optimized tables in sql server 2014

We can get the list of all memory optimized tables in the current database by following sql query:

SELECT
     SCHEMA_NAME([schema_id]) AS SchemaName,
     name AS TableName
FROM sys.tables
WHERE is_memory_optimized = 1

Sample Output:

SchemaName
TableName
dbo
tblEmployee
dbo
tblSkills
dbo
tblType



Here sys.tables is a system view. 

No comments:

Post a Comment