SQL$HELP_OLD72.HLB  —  SHOW  Format
  SHOW   --+->  show-params-1 --------------+-->
           +->  show-params-2 --------------+
           +->  show-session-information ---+

  show-params-1 =

  ----+-> show-aliases --------------+--->
      +-> show-cache ----------------+
      +-> show-catalogs -------------+
      +-> CHARACTER SETS ------------+
      +-> show-collating-sequence ---+
      +-> show-connections ----------+
      +-> CURSORS -------------------+
      +-> show-databases ------------+
      +-> DISPLAY -------------------+
      +-> show-domains --------------+
      +-> FLAGS ---------------------+
      +-> show-functions ------------+
      +-> show-indexes --------------+
      +-> show-journals -------------+
      +-> show-modules --------------+
      +-> show-outlines -------------+

  show-params-2 =

  --+-> show-profiles -------------+->
    +-> show-privileges -----------+
    +-> show-procedures -----------+
    +-> QUERY CONFIRM -------------+
    +-> QUERY LIMIT ---------------+
    +-> show-roles ----------------+
    +-> show-schemas --------------+
    +-> show-sequences ------------+
    +-> show-storage-areas --------+
    +-> show-storage-maps ---------+
    +-> show-synonyms -------------+
    +-> show-tables ---------------+
    +-> show-triggers -------------+
    +-> show-users ----------------+
    +-> show-users-granting -------+
    +-> show-users-with -----------+
    +-> VARIABLES -----------------+
    +-> show-views ----------------+

  show-aliases =

  --> ALIASES  --+----------------+-->
                 +-+-> <alias> -+-+
                 | +----- , <---+ |
                 +---> * ---------+

  show-cache =

  ---> CACHE -+---------------------+-->
              +---> <name-list> ----+

  show-catalogs =

  ---> CATALOGS --+-----------------+->
                  +-> name-list ----+

  show-collating-sequence =

  ---> COLLATING SEQUENCE --+---------------+-->
                            +-> name-list --+

  show-connections =

  ---> CONNECTIONS -+-+---------------------+-+->
                    | +-> DEFAULT ----------+ |
                    | +-> CURRENT ----------+ |
                    | +-> <connection-name> + |
                    +------------- , <--------+

  show-databases =

  --> DATABASES --+----------------+-->
                  +-+-> <alias> -+-+
                  | +----- , <---+ |
                  +---> * ---------+

  show-domains =

  -+-----------+-> DOMAINS -+---------------+-->
   +-> SYSTEM -+            +-> name-list --+
   +-> ALL ----+

  show-functions =

  -+------------+-> FUNCTIONS +-----------------------------+-+---------------+->
   +-> SYSTEM  -+             +> ( ++-> COMMENT -----++> ) -+ +-> name-list  -+
   +-> ALL -----+                  |+-> ID ----------+|
                                   |+-> LANGUAGE ----+|
                                   |+-> MODULE ------+|
                                   |+-> OWNER -------+|
                                   |+-> PARAMETER ---+|
                                   |+-> SOURCE ------+|
                                   +------- , <-------+

  show-indexes =

  -+-----------++-> INDEXES -+-+---------------------------------------+->
   +-> SYSTEM -++-> INDICES -+ +-> ON -+> <table-name> ----------------+
   +-> ALL ----+               |       +----- , <----------------------+
                               +-> name-list --------------------------+
                               +-> ( -+-> CARDINALITY  +> name-list ) -+
                                      +-- PARTITIONS   |
                                      +------- , ------+

  show-journals

  ---> JOURNALS -+----------------+-->
                 +--> name-list --+

  show-modules =

  -+------------+-> MODULES  -+----------------------------+-+---------------+->
   +-> SYSTEM  -+             +> ( ++> COMMENT ----++> ) --+ +-> name-list  -+
   +-> ALL -----+                  |+> FUNCTIONS --+|
                                   |+> ID ---------+|
                                   |+> NAME -------+|
                                   ||> OWNER ------+|
                                   |+> PROCEDURES -+|
                                   |+> VARIABLES --+|
                                   +------ , <------+

  show-outlines

  ---> OUTLINES -+---------------+-->
                 +-> name-list --+

  show-profiles =

  --> PROFILES -+---------------+-->
                +-> name-list --+

  name-list =

  -+-+---------------++- * --------------+-+->
   | +-> <alias> . --++-> <object-name> -+ |
   |                                       |
   +----------------- , <------------------+

  show-privileges =

  --+-> PROTECTION ON -++-> TABLES ----+-> <table-name> +----------+->
    |                  ||              +------- , <-----+          |
    +-> PRIVILEGES ON -++-> VIEWS -----+-> <view-name> -+----------+
                        |              +------- , <-----+          |
                        +-> COLUMNS ---+-> <column-name> -+--------+
                        |              +------- , <-------+        |
                        +-> DATABASE --+-> <alias> +---------------+
                        |              +---- , <---+               |
                        +-> FUNCTION --+-> <function-name> ----+---+
                        |              +----------- , <--------+   |
                        +-> PROCEDURE -+-> <procedure-name> -----+-+
                        |              +----------- , <----------+ |
                        +-> MODULE ----+-> <module-name> +---------+
                        |              +------- , <------+         |
                        +-> SEQUENCE --+-> <sequence-name> -+------+
                                       +------------ , <----+

  show-procedures =

   -+-----------+--> PROCEDURES +--------------------------++---------------+->
    +-> SYSTEM -+               +> ( ++> COMMENT ----++> ) ++-> name-list --+
    +-> ALL ----+                    |+> ID ---------+|
                                     |+> LANGUAGE ---+|
                                     |+> MODULE -----+|
                                     |+> OWNER ------+|
                                     |+> PARAMETER --+|
                                     |+> SOURCE -----+|
                                     +------ , <------+

  show-roles =

  ---> ROLES -+--------------+->
              +-> name-list -+

  show-schemas =

  --> SCHEMAS -+---------------+->
               +-> name-list --+

  show-sequences=

  ---> SEQUENCES -+---------------+->
                  +-> name-list --+

  show-storage-areas =

  --> STORAGE AREAS --+---------------------------------------+->
                      +-> name-list --------------------------+
                      +-> ( ++> USAGE -------++> ) name-list -+
                            |+> ATTRIBUTES --+|
                            +----- , <--------+

  show-storage-maps =

  -+-----------+-> STORAGE MAPS -+----------------+--------------------+->
   +-> SYSTEM -+                 +-> name-list ---+                    |
   +-> ALL ----+                 +-> ( PARTITIONS -> ) -> name-list  --+

  show-synonyms =

  ---> SYNONYMS -+---------------+-->
                 +-> name-list --+

  show-tables =

  -+-----------+-> TABLES -+-------------------------------------------+->
   +-> SYSTEM -+           +-> name-list ------------------------------+
   +-> ALL ----+           +-> ( -++-> COLUMNS -----++-> ) name-list --+
                                  |+-> COMMENT -----+|
                                  |+-> CONSTRAINTS -+|
                                  |+-> INDEXES -----+|
                                  |+-> STORAGE MAPS +|
                                  |+-> TRIGGERS ----+|
                                  +-------- , <------+

  show-triggers =

  -+-----------+-> TRIGGERS -+---------------+-->
   +-> SYSTEM -+             +-> name-list --+
   +-> ALL ----+

  show-users =

  ---> USERS --+---------------+-->
               +-> name-list --+

  show-users-granting =

  --> USERS GRANTING ---+
  +---------------------+
  ++> db-privs-ansi  ------> ON DATABASE -+-> <alias> +-----------------++
   |                                      +---- , <---+                 ||
   +> table-privs-ansi ----> ON TABLE  -+-> <table-name> +--------------+|
   |                                    +------- , <-----+              ||
   +> column-privs-ansi ---> ON COLUMN -+-> <column-name> --+-----------+|
   |                                    +------- , <--------+           ||
   +> ext-routine-privs-ansi +-> ON FUNCTION +> <function-name -----+---+|
   |                         |               +--------- , <---------+   ||
   |                         +--> ON PROCEDURE +> <procedure-name -----++|
   |                                           +--------- , <----------+||
   +> module-privs-ansi ---> ON MODULE --+-> <module-name> --+----------+|
   |                                     +----- , <----------+          ||
   +> sequence-privs-ansi --> ON SEQUENCE -+> <sequence-name> -+--------+|
                                           +--- , <------------+         |
     +-------------------------------------------------------------------+
     +---> TO -+-> identifier-ansi-style ---+--->
               +-> PUBLIC ------------------+

  show-views =

  --+-----------+-> VIEWS -+------------------------------+-+
    +-> SYSTEM -+          +-> ( -+-+-> COLUMNS -+-+-> ) -+ |
    +-> ALL ----+                 | +-> COMMENT -+ |        |
                                  | +-> SOURCE --+ |        |
                                  +------ , <------+        |
   +--------------------------<-----------------------------+
   +-+---------------+------------->
     +-> name-list --+

  db-privs-ansi =

  ----+---+-+-> SELECT -----+-+----+->
      |   | +-> INSERT -----+ |    |
      |   | +-> OPERATOR ---+ |    |
      |   | +-> DELETE -----+ |    |
      |   | +-> CREATE -----+ |    |
      |   | +-> ALTER ------+ |    |
      |   | +-> DROP -------+ |    |
      |   | +-> DBCTRL -----+ |    |
      |   | +-> DBADM ------+ |    |
      |   | +-> SHOW -------+ |    |
      |   | +-> REFERENCES -+ |    |
      |   | +-> UPDATE -----+ |    |
      |   | +-> SECURITY ---+ |    |
      |   | +-> DISTRIBTRAN + |    |
      |   +------- , <--------+    |
      +-------> ALL PRIVILEGES ----+

  table-privs-ansi =

  -+--+-+-> SELECT -------------------------------+-+-+->
   |  | +-> INSERT -------------------------------+ | |
   |  | +-> OPERATOR -----------------------------+ | |
   |  | +-> DELETE -------------------------------+ | |
   |  | +-> CREATE -------------------------------+ | |
   |  | +-> ALTER --------------------------------+ | |
   |  | +-> DROP ---------------------------------+ | |
   |  | +-> DBCTRL -------------------------------+ | |
   |  | +-> SHOW ---------------------------------+ | |
   |  | +-> REFERENCES +--------------------------+ | |
   |  | |              +> ( +> <column-name> +> ) + | |
   |  | |                   +----- , <-------+    | | |
   |  | +-> UPDATE +----------------------  ------+ | |
   |  |            +> ( +> <column-name> -+---> ) + | |
   |  |                 +----- , <--------+         | |
   |  +------------------- , <----------------------+ |
   +------> ALL PRIVILEGES ---------------------------+

  column-privs-ansi =

  ---+-+-+-> UPDATE -----+-+--+-->
     | | +-> REFERENCES -+ |  |
     | +------- , <--------+  |
     +-----> ALL PRIVILEGES --+

  ext-routine-privs-ansi =

  -+--+-+-> ALTER ------------------------------+-+--+-->
   |  | +-> DBCTRL -----------------------------+ |  |
   |  | +-> DROP -------------------------------+ |  |
   |  | +-> EXECUTE ----------------------------+ |  |
   |  | +-> REFERENCES -------------------------+ |  |
   |  | +-> SHOW -------------------------------+ |  |
   |  +------------------- , <--------------------+  |
   +------> ALL PRIVILEGES --------------------------+

  module-privs-ansi =

  -+--+-+-> ALTER ------------------------------+-+--+-->
   |  | +-> DBCTRL -----------------------------+ |  |
   |  | +-> DROP -------------------------------+ |  |
   |  | +-> EXECUTE ----------------------------+ |  |
   |  | +-> REFERENCES -------------------------+ |  |
   |  | +-> SHOW -------------------------------+ |  |
   |  +------------------- , <--------------------+  |
   +------> ALL PRIVILEGES --------------------------+

  identifier-ansi-style =

  ------> user-identifier -------->

  show-users-with =

  --> USERS WITH -------+
  +---------------------+
  ++> db-privs-ansi  -------> ON DATABASE -+-> <alias> +-----------------++
   |                                       +---- , <---+                 ||
   +> table-privs-ansi -----> ON TABLE  -+-> <table-name> +--------------+|
   |                                     +------- , <-----+              ||
   +> column-privs-ansi ----> ON COLUMN -+-> <column-name> -+------------+|
   |                                     +------- , <-------+            ||
   +> ext-routine-privs-ansi -+> ON FUNCTION -+> <function-name> ----+---+|
   |                          |               +--------- , <---------+   ||
   |                          +-> ON PROCEDURE -+> <procedure-name> ----++|
   |                                            +--------- , <----------+||
   +> module-privs-ansi ----> ON MODULE --+-> <module-name> +------------+|
   |                                      +----- , <--------+            ||
   +> sequence-privs-ansi --> ON SEQUENCE -+-> <sequence-name> -+--------+|
                                           +---- , <------------+         |
     +--------------------------------------------------------------------+
     +--> FROM +-> identifier-ansi-style ---+--->
               +-> PUBLIC ------------------+

  sequence-privs-ansi =

  -+-+-+-> ALTER -----+-+-+-->
   | | +-> DBCTRL ----+ | |
   | | +-> DROP ------+ | |
   | | +-> SELECT ----+ | |
   | +------- , <-------+ |
   +--> ALL PRIVILEGES ---+

  show-session-information =

  -+-> ANSI DATE MODE -----------+->
   +-> ANSI IDENTIFIERS MODE ----+
   +-> ANSI QUOTING MODE --------+
   +-> AUTOMATIC TRANSLATION ----+
   +-> CONSTRAINT MODE ----------+
   +-> CONTINUATION CHARACTER ---+
   +-> CURRENCY SIGN ------------+
   +-> DATE FORMAT --------------+
   +-> DICTIONARY ---------------+
   +-> DIGIT SEPARATOR ----------+
   +-> DISPLAY ------------------+
   +-> EXECUTION MODE -----------+
   +-> FLAGGER MODE -------------+
   +-> HOLD CURSORS MODE --------+
   +-> LANGUAGE -----------------+
   +-> RADIX POINT --------------+
   +-> SQLCA --------------------+
   +-> TRANSACTION --------------+
   +-> VERSIONS -----------------+
   +-> WARNING MODE -------------+
Close Help