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 INTEGER Internal use only.
table_autoinc BIG Internal use only.
Constraints

PRIMARY INDEX (table_id)