Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite database reference » UltraLite Java edition system tables


systable system table

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

Column name Column type Description
table_id UNSIGNED 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
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.