Primary System Tables

Table 1-1 shows the name and description of the primary system tables that store SQL objects.

Table 1-1 Primary system tables that store SQL objects

Name	Description
SYS.CACHE_GROUP	Stores data about cache groups Returns 0 rows in TimesTen Scaleout
SYS.COLUMNS	Stores data about the columns in a table
SYS.INDEXES	Stores data about indexes on table columns
SYS.SEQUENCES	Stores data about sequences
SYS.TABLES	Stores data about tables
SYS.TRANSACTION_LOG_API	Stores data about the persistent Transaction Log API bookmarks Returns 0 rows in TimesTen Scaleout
SYS.VIEWS	Stores data about views
SYS.XLASUBSCRIPTIONS	Stores data about table subscriptions at the bookmark level Returns 0 rows in TimesTen Scaleout