Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

TABLES

This view 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 (SQL timestamp).

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.

ALTER_TIME

Time of the most recent change to the table (SQL timestamp) or the CREATE_TIME if the table has not been altered.

ALTER_USER

Name of the user that made the most recent change to the table.

CREATE_USER

Name of the user that created the table.

Last modified:

Was this article helpful?