information_schema.TABLES

This table contains information about the tables visible to the current node.

Column Name

Description

TABLE_CATALOG

Always = def.

TABLE_SCHEMA

The database the table belongs to (could be partitioned database, i.e., db_0).

TABLE_NAME

Name of the table.

TABLE_TYPE

The type of the table (i.e., SYSTEM VIEW, VIEW, TEMPORARY TABLE, GLOBAL TEMPORARY TABLE, or BASE TABLE).

ENGINE

Always = MemSQL.

VERSION

NULL (currently unsupported).

ROW_FORMAT

COMPRESSION = SPARSE if sparse compression is used.

TABLE_ROWS

Row count for the table.

AVG_ROW_LENGTH

NULL (currently unsupported).

DATE_LENGTH

NULL (currently unsupported).

MAX_DATA_LENGTH

NULL (currently unsupported).

INDEX_LENGTH

NULL (currently unsupported).

DATA_FREE

NULL (currently unsupported).

AUTO_INCREMENT

The auto increment counter of the auto increment column (or NULL if not in use).

CREATE_TIME

Time the table was created.

UPDATE_TIME

NULL (currently unsupported).

CHECK_TIME

NULL (currently unsupported).

TABLE_COLLATION

NULL (currently unsupported).

CHECKSUM

NULL (currently unsupported).

CREATE_OPTIONS

NULL (currently unsupported).

TABLE_COMMENT

Comment from the CREATE TABLE statement, if specified.

DISTRIBUTED

1 if table is sharded, 0 otherwise.

STORAGE_TYPE

COLUMNSTORE for columnstore databases. INMEMORY_ROWSTORE for rowstore.