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. |
| indexcol_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(128) | 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_name | VARCHAR(128) | The name of the table. |
| table_type | TINYINT | One of either sys for system tables or user for regular tables. |
| tpd_handle | UNSIGNED INT | Internal user only. |
PRIMARY KEY (object_id)
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |