SQL$HELP72.HLB  —  SHOW  Arguments  SYSTEM
    Controls whether SQL displays system-defined domains, indexes,
    storage maps, tables, or views in the SHOW DOMAINS, SHOW
    FUNCTIONS, SHOW INDEXES, SHOW MODULES, SHOW STORAGE MAPS, SHOW
    TABLES, SHOW TRIGGERS, and SHOW VIEWS statements.

    o  If you do not specify either SYSTEM or ALL, the display
       includes only user-defined elements.

    o  If you specify SYSTEM, the display includes elements created
       for use by the database system, or layered applications such
       as the OCI Services component of SQL/Services.

    o  If you specify ALL, the display includes both user-defined and
       system-defined elements.
Close Help