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 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |