Locations of System Tables

Some system tables are located only in the master, sybsecurity, or sybsystemdb databases, while others may be located in all databases.

Most tables in the master database are system tables. Some of these tables also occur in user databases. They are automatically created when the create database command is issued.

• System Tables in master
  Certain system tables occur only in the master database.
• System Tables in sybsecurity
  Two audit-related system tables occur only in the sybsecurity database:
• System Table in sybsystemdb
  The syscoordinations system table, which consists of one row for each remote participant of a distributed transaction, occurs only in sybsystemdb.
• System Tables in All Databases
  Certain system tables occur in all databases.
• The sybdiagdb Database
  SAP Product Support may create the sybdiagdb database on your system for debugging purposes. This database holds diagnostic configuration data for use by Product Support representatives.
• The syblicenseslog Table
  The syblicenseslog table is described in syblicenseslog. It is not technically a system table, but you may need to consult it for license information related to shutting down the SAP ASE server.