SYSTABLES

Describes the tables and views in the distributed system.

Table 1. SYSTABLES system table
Column Name Type Length Nullable Contents
TABLEID CHAR 36 No Unique identifier for table or view
TABLENAME VARCHAR 128 No Table or view name
TABLETYPE CHAR 1 No 'S' (system table), 'T' (user table), 'A' (synonym), or 'V' (view)
SCHEMAID CHAR 36 No Schema ID for the table or view
TABLESCHEMANAME VARCHAR 128 No The table schema
LOCKGRANULARITY CHAR 1 No Lock granularity for the table: 'T' (table level locking) or 'R' (row level locking, the default)
SERVERGROUPS VARCHAR 128 No The server groups assigned to the table
DATAPOLICY VARCHAR 24 No Table partitioning and replication status
PARTITIONATTRS LONG VARCHAR 32,700 Yes For partitioned tables, displays the additional partitioning attributes assigned with the CREATE TABLE statement, such as colocation, buckets, and redundancy values
RESOLVER LONG VARCHAR 32,700 Yes The partitioning resolver (contains the partitioning clause).
EXPIRATIONATTRS LONG VARCHAR 32,700 Yes Row expiration settings
EVICTIONATTRS LONG VARCHAR 32,700 Yes Row eviction settings
DISKATTRS LONG VARCHAR 32,700 Yes Table persistence settings
LOADER VARCHAR 128 Yes A RowLoader associated with the table using SYS.ATTACH_LOADER.
WRITER VARCHAR 128 Yes An event writer associated with the table using SYS.ATTACH_WRITER.
LISTENERS LONG VARCHAR 32,700 Yes A comma-separated list of event listeners that were associated with the table using SYS.ADD_LISTENER.
ASYNCLISTENERS VARCHAR 256 Yes A comma-separated list of AsyncEventListeners that were installed on the table using CREATE ASYNCEVENTLISTENER. See Displaying Installed AsyncEventListeners.
GATEWAYENABLED BOOLEAN 1 No Indicates whether a gateway has been enabled on the table, or an AsyncEventListener has been associated with the table.
GATEWAYSENDERS VARCHAR 256 Yes A comma-separated list of gateway senders that were installed on the table.

See Configuring Multi-site (WAN) Deployments.