System tables

The master database contains system tables that keep track of information about Adaptive Server as a whole. In addition, each database (including the master database) contains system tables that keep track of information specific to that database.

All the Adaptive Server-supplied tables in the master database (Adaptive Server’s controlling database) are considered system tables. Each user database is created with a subset of these system tables. The system tables may also be referred to as the data dictionary or the system catalogs.

A master database and its tables are created when Adaptive Server is installed. The system tables in a user database are created when the create database command is issued. The names of all system tables start with “sys”. You cannot create tables in user databases that have the same names as system tables. An explanation of the system tables and their columns is included in the Reference Manual.