systable system table

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

Column name Column type Description
column_count UNSIGNED INT The number of columns in the table.
index_count UNSIGNED INT The number of indexes in the table.
ixcol_count UNSIGNED INT The total number of columns in all indexes in the table.
map_handle UNSIGNED INT Internal use only.
table_name VARCHAR(128) The name of the table.
object_id UNSIGNED INT A unique identifier for that table.
sync_type VARCHAR(32) Used for MobiLink synchronization. Can be one of either no_sync for no synchronization, all_sync to synchronize every row, or normal_sync for synchronize changed rows only.
table_type VARCHAR(32) user to indicate user-created tables.
tpd_handle UNSIGNED INT Internal user only.
 Constraints