Entering content frame

This graphic is explained in the accompanying text Evaluating System Tables (Examples) Locate the document in the library structure

Prerequisites

You have generated the demo data for the SQL Tutorial.

Log on to the demo database instance DEMODB as user MONA.

Examples

There are example evaluations for the following system tables:

Structure linkACTIVECONFIGURATION

Structure linkCACHESTATISTICS

Structure linkCOLUMNS

Structure linkCONSTRAINTS

Structure linkDATASTATISTICS

Structure linkDATAVOLUMES

Structure linkDBPROCEDURES

Structure linkDBPROCPARAMS

Structure linkDOMAINCONSTRAINTS

Structure linkDOMAINS

Structure linkFOREIGNKEYCOLUMNS

Structure linkFOREIGNKEYS

Structure linkFUNCTIONS

Structure linkINDEXCOLUMNS

Structure linkINDEXES

Structure linkINSTANCE

Structure linkLOCKS

Structure linkLOGQUEUESTATISTICS

Structure linkLOGSTATISTICS

Structure linkMAPCHARSETS

Structure linkROLEPRIVILEGES

Structure linkROLES

Structure linkSEQUENCES

Structure linkSESSION_ROLES

Structure linkSESSIONS

Structure linkSYNONYMS

Structure linkTABLEPRIVILEGES

Structure linkTABLES

Structure linkTRIGGERS

Structure linkUSERS

Structure linkVERSION

Structure linkVIEWCOLUMNS

Structure linkVIEWDEFS

Structure linkVIEWS

 

See also:

Structure linkDatabase Terms

Structure linkDefinitions of the System Tables

 

Leaving content frame