Filter
Top Products
System tables and views
12
System tables and views
Adaptive Server IQ system tables contain all of the information the database
server needs to manage your IQ system. The system tables reside in the Catalog
Store, and are sometimes called catalog tables. For some system tables there
are also views that make it easier to display the information in the table. The
SYS user ID owns the system tables.
Among the information in the system tables is:
• Database characteristics
• Table characteristics, including table definitions and information about the
size and location of each table
• Information about indexes
• Current settings for database and DBISQL options
System tables include:
sp_servercaps Display information about a remote
server’s capabilities
Procedure name Purpose
System table Description
DUMMY A table with exactly one row, useful
for extracting information from the
database
SYSARTICLE Describes an article in a SQL Remote
publication
SYSARTICLECOL Describes columns in each article in a
SQL Remote publication
SYSCOLLATION Contains the complete collation
sequences available to Adaptive
Server IQ
SYSCOLLATIONMAPPINGS Lists the collation sequences available
in Adaptive Server IQ and their GPG
and JDK mappings
SYSCOLUMN Describes each column in every table
or view