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