DAX System tables

DAX system tables contain data that the DAX kernel uses to control the behavior of the kernel. DAX system tables are created automatically by the kernel when DAX is started for the first time against an empty database or after a service pack upgrade.

ACCESSRIGHTSLIST

This table contains info about explicit granted access rights for the defined user groups.

COMPANYDOMAINLIST

This table contains relation between companies and domains.

DATAAREA

This table contains data about created companies.

DATABASELOG

This table contains data about which tables and events to log. The events are logged in the DAX tableSysDatabaseLog.

DOMAININFO

This table contains data about domains.

PRINTJOBHEADER

This table is used in connection with printing from DAX.

PRINTJOBPAGES

This table is used in connection with printing from DAX.

SQLDESCRIBE

This table is used temporarily during check / synchronisation process and should normally be empty.

SQLDICTIONARY

This table contains data dictionary data about DAX application and system tables (except SQLstemVariables) as stored in DAX data dictionary.

SYSCONFIG

This table contains license information, version, feature key setup, and other basic system configuration data.

USERGROUPLIST

Table describes relation between users and user groups.

USERINFO

Table is used to store general setup.