|
Each row in the systable system table describes one table in the database.
| Column name | Description | Type | Data constraint | Integrity constraints |
|---|---|---|---|---|
|
column_count |
The number of columns in the table. |
UNSIGNED INT |
NOT NULL | |
|
index_count |
The number of indexes in the table. |
UNSIGNED INT |
NOT NULL | |
|
indexcol_count |
The total number of columns in all indexes in the table. |
UNSIGNED INT |
NOT NULL | |
|
map_handle |
Used internally only. |
UNSIGNED INT |
NOT NULL | |
|
table_name |
The name of the table. |
VARCHAR(128) |
NOT NULL | |
|
object_id |
A unique identifier for that table. |
UNSIGNED INT |
NOT NULL |
Primary key. |
|
sync_type |
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. |
VARCHAR(128) |
NOT NULL | |
|
table_name |
The name of the table. |
VARCHAR(128) |
NOT NULL | |
|
table_type |
One of either sys for system tables or user for regular tables. |
TINYINT |
NOT NULL | |
|
tpd_handle |
Internal user only. |
UNSIGNED INT |
NOT NULL |