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:

  • TableSchema.TABLE_IS_SYSTEM
  • TableSchema.TABLE_IS_NO_SYNC
  • TableSchema.TABLE_IS_DOWNLOAD_ONLY
table_data UNSIGNED INTEGER Internal use only.
table_partition_size UNSIGNED INTEGER

The partition size of the table, if specified or if the table contains a default value; otherwise, null.

This value is 0 if the partition size is out of range.
 Constraints
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1