M_TABLES System View

Information on row and column tables, as well as collection tables (JSON Document Store).

Structure

Column name

Data type

Description

SCHEMA_NAME

NVARCHAR(256)

Schema name

TABLE_NAME

NVARCHAR(256)

Table name

RECORD_COUNT

BIGINT

Number of records in this table

TABLE_SIZE

BIGINT

Allocated memory size for fixed-size and variable-size part

IS_COLUMN_TABLE

VARCHAR(5)

Specifies whether the table is a column table: TRUE, FALSE

TABLE_TYPE

VARCHAR(16)

Specifies type of the table: ROW, COLUMN, COLLECTION

IS_PARTITIONED

VARCHAR(5)

Specifies whether the table is partitioned: TRUE, FALSE

IS_REPLICATED

VARCHAR(5)

Specifies whether the table is replicated: TRUE, FALSE