systable system table

Each row in the systable system table describes a table in the database.

Column name Column type Description
table_id INTEGER A unique identifier for the table.
table_name VARCHAR(128) The name of the table.
table_flags UNSIGNED SHORT

A bitwise combination of one of the following flags:

  • TABLE_IS_SYSTEM
  • TABLE_IS_NO_SYNC
table_data UNSIGNED INTEGER Internal use only.
table_partition_size UNSIGNED INTEGER

The partition size of the table, if specified or if the table contains a default value; otherwise, null.

This value is 0 if the partition size is out of range.

 Constraints