WINDOWS Live Search

To contact me for any clarifications regarding any posts / information, please mail me at arijit [dot] basu [at] gmail [dot] com


Saturday, December 2, 2006

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.


{Please use them with utmost care}

No comments: