SHOW  --+-> show-collating-sequence ---+-->
         +-> show-domains --------------+
         +-> show-indexes --------------+
         +-> show-protection -----------+
         +-> show-schema ---------------+
         +-> show-session-information --+
         +-> show-storage-areas --------+
         +-> show-storage-maps ---------+
         +-> show-tables ---------------+
         +-> show-triggers -------------+
         +-> show-users-granting--------+
         +-> show-users-with -----------+
         +-> show-views ----------------+

Additional information available:

More Informationcollating sequencesdomainsindexesprotection
schemassession informationstorage areasstorage mapstablestriggers
users grantingusers withviews

 The SHOW statement displays information about the schema and its
 definitions, and information about the current interactive SQL
 session.  You can use the SHOW statement only in interactive
 SQL.

 show-collating-sequence =

 ---> COLLATING SEQUENCE --+-----------------+->
                           +- sequence-name -+

 A collating sequence is the sequence in which characters are
 ordered for sorting, merging, and comparing.  The VMS National
 Character Set (NCS) provides a set of predefined collating
 sequences and lets you define collating sequences of your own.

 show-domains =
 -+-----------+-> DOMAINS -+-+----------------------+-+-->
  +-> SYSTEM -+            | +-+-------------+-> * -+ |
  +-> ALL ----+            | | +-> auth-id. -+      | |
                           | +-> domain-name -------+ |
                           +----------- , <-----------+

 Displays the names and data types of specified domains.  If you
 specify SHOW DOMAINS without any arguments, VAX SQL displays
 definitions of all domains in all declared schemas.

 show-indexes =
 -+-----------+-> INDEXES -+------------------------------+-->
  +-> SYSTEM -+            +-+-+-+-------------+-> * -+-+-+
  +-> ALL ----+            | | | +-> auth-id. -+      | | |
                           | | +-> index-name --------+ | |
                           | +----------- , <-----------+ |
                           +-> ON -+-> table-name -+------+
                                   +------ , <-----+

 Displays information about specified indexes.  SQL displays the
 name of the index, the associated column and table, and whether
 the definition allows duplicate values for the column.  If you
 specify SHOW INDEXES without any arguments, SQL displays
 definitions of all indexes in all declared schemas.

 show-protection =
 --+-> PROTECTION ON -++-> TABLES -+-> table-name  -+-+----------+->
   |                  ||           +------- , <-----+ |          |
   +-> PRIVILEGES ON -++-> VIEWS --+-> view-name  --+-+          |
                       |           +------- , <-----+ |          |
                       +-> COLUMN  +-> column-name -+-+          |
                       |           +------- , <-----+            |
                       +-> SCHEMAS AUTHORIZATION -+-> auth-id -+-+
                                                  +----- , <---+

 SHOW PROTECTION displays all the entries in the access privilege
 set for the specified schemas, tables, or columns.  SHOW
 PRIVILEGES displays only your access privilege set entry for the
 specified schemas, tables, or columns.

 In an ANSI style database, the SHOW USERS GRANTING and SHOW
 USERS WITH statements display which privileges have the option
 of being granted to other users and which privileges are without
 the grant option.

 show-schema =

 --> SCHEMAS AUTHORIZATION -+----------------+-->
                            +-+-> auth-id -+-+
                              +----- , <---+

 Displays information about the specified schemas.  For each
 schema, SQL displays the authorization identifier and the file
 specification for the database system root file.  If the schema
 was declared using a data dictionary path name, SQL also
 displays that path name.

 If you do not specify any authorization identifiers with SHOW
 SCHEMAS, SQL displays information about all declared schemas.

 show-session-information =

 -+-> CURRENCY SIGN -----+->
  +-> CONSTRAINT MODE ---+
  +-> DATE FORMAT -------+
  +-> DICTIONARY --------+
  +-> DIGIT SEPARATOR ---+
  +-> LANGUAGE ----------+
  +-> RADIX POINT -------+
  +-> TRANSACTION -------+
  +-> VERSIONS ----------+
  +-> SQLCA -------------+

 SHOW CONSTRAINT MODE shows the initial setting of the constraint
 mode for any transactions starting after the current
 transaction.  When the constraint mode is ON, SQL evaluates all
 commit-time constraints at the end of each statement and at
 commit time, until the transaction completes or the constraint
 mode set to OFF.  When the constraint mode is OFF (the default
 setting), constraint evaluation is deferred until commit time.

 SHOW CURRENCY SIGN displays the currency indicator which will be
 used in output displays.

 SHOW DATE FORMAT displays the values for the date-number and
 time-number arguments of the SET DATE FORMAT DATE date-number
 and SET DATE FORMAT TIME time-number statements.

 SHOW DICTIONARY displays the current default directory in the
 data dictionary.

 SHOW DIGIT SEPARATOR displays the character which will be used
 as the digit separator in output displays.

 SHOW LANGUAGE displays the language that will be used for month
 abbreviations in date and time input and display.

 SHOW RADIX POINT displays the character that will be used as the
 radix point in output displays.

 SHOW TRANSACTION displays the characteristics of the current
 transaction, or, if there is not an active transaction, the
 characteristics specified in the last DECLARE TRANSACTION
 statement.

 SHOW VERSIONS displays the version of SQL and underlying
 software components.

 SHOW SQLCA displays the contents of the SQL Communication Area
 (SQLCA).  The SQLCA is a collection of variables that SQL uses
 to provide information about the execution of SQL statements to
 application programs.  In interactive SQL, you can use the SHOW
 SQLCA statement to learn about the different variables in the
 SQLCA.

 show-storage-areas =

 --> STORAGE AREAS ---+----------------------------+-->
                      ++-+-+-------------+-> * -+-++
                       | | +-> auth-id. -+      | |
                       | +-> storage-area-name -+ |
                       +----------- , <-----------+

 Displays information about the storage areas for the declared
 schema.  The information includes:  page format, page size, area
 file, area allocation, area extent minimum, area extent maximum,
 area extent percent, snapshot file, snapshot allocation,
 snapshot extent minimum, snapshot extent maximum, and snapshot
 extent percent.

 show-storage-maps =
 -+----->-----+-> STORAGE MAPS -+-+----------->----------+-+-->
  +-> SYSTEM -+                 | +-+-------------+-> * -+ |
  +-> ALL ----+                 | | +-> auth-id. -+      | |
                                | +-> storage-map-name --+ |
                                +----------- , <-----------+

 Displays information about the storage maps for the declared
 schema.  The display includes:  whether compression is enabled
 or disabled, and information you specified in the store-clause
 of the CREATE STORAGE MAP statement.

 show-tables =
 -+----->-----+-> TABLES  -+------------------>----------------+-+
  +-> SYSTEM -+            +-> ( -+-+-> COLUMNS ------+-+-> ) -+ |
  +-> ALL ----+                   | +-> COMMENT ------+ |        |
                                  | +-> CONSTRAINTS --+ |        |
                                  | +-> INDEXES ------+ |        |
                                  | +-> STORAGE MAPS -+ |        |
                                  | +-> TRIGGERS -----+ |        |
                                  +--------- , <--------+        |
  +------------------------------<-------------------------------+
  +--+-+----------->----------+-+-->
     | +-+-------------+-> * -+ |
     | | +-> auth-id. -+      | |
     | +-> table-name --------+ |
     +---------- , <------------+

 Displays information about tables.  If you do not specify a
 wildcard or list of table names, SQL displays the names of all
 the tables in all declared schemas.

 If you do not specify any of the SHOW TABLES options (COLUMNS,
 COMMENT, CONSTRAINTS, INDEXES, STORAGE MAPS, or TRIGGERS), by
 default you will see the display for all of these options.

Additional information available:

COLUMNSCOMMENTCONSTRAINTSINDEXESSTORAGE_MAPS
TRIGGERS

 Displays each column name, data type, and domain name for the
 specified tables.

 Displays the comments for the specified tables.

 Displays the constraints for the specified tables and the
 constraints referencing the specified tables.  The display shows
 the name and type of each constraint, its evaluation time, and
 its source definition.

 Displays the indexes for the specified tables.  The display
 shows the name and type of each index and whether duplicates are
 allowed.

 Displays the names of the storage maps for the specified tables.

 Displays the names and source definitions of triggers for the
 specified tables.

 show-triggers =
 TRIGGERS -+-+----------->----------+-+-->
           | +-+------>------+-> * -+ |
           | | +-> auth-id. -+      | |
           | +-> trigger-name ------+ |
           +----------- , <-----------+
 Displays information about triggers.  If you do not specify a
 wildcard or a trigger name, SQL displays the names of all the
 triggers in all declared schemas.

 show-users-granting =

 --> USERS GRANTING ---+
  +--------------------+
  +-+-> table-privs-ansi --+-> ON +-> TABLE  -+-> table-name  -+-+--+
    +-> column-privs-ansi -+      |           +------- , <-----+ |  |
    +-> schema-privs-ansi -+      +-> COLUMN -+-> column-name -+-+  |
                                  |           +------- , <-----+ |  |
                                  +-> SCHEMA -+-> schema-name -+-+  |
                                              +------- , <-----+    |
       +------------------------------------------------------------+
       +-+-> TO identifier-ansi-style --+--> ;
         +-> PUBLIC --------------------+

 Displays information about the users who gave a particular
 privilege to a particular user.  This statement displays the
 privilege records that need to be revoked to take a privilege
 away from the user, either directly or indirectly.

 You can specify a list of tables, columns, or schema but you
 must specify at least one item to display a table, column, or
 schema list.

 For lists of privileges, see the column_privs, schema_privs, and
 table_privs subtopics of the Help topic for GRANT_ANSI_style.

Additional information available:

TO

 Specifies the identifiers for the new or modified access
 privilege set entry.  Specifying PUBLIC is equivalent to using
 the user identification code (UIC) identifier [*,*].

 show-users-with =

 --> USERS WITH -------+
  +--------------------+
  +-+-> table-privs-ansi --+-> ON +-> TABLE  -+-> table-name  -+-+--+
    +-> column-privs-ansi -+      |           +------- , <-----+ |  |
    +-> schema-privs-ansi -+      +-> COLUMN -+-> column-name -+-+  |
                                  |           +------- , <-----+ |  |
                                  +-> SCHEMA -+-> schema-name -+-+  |
                                              +------- , <-----+    |
       +------------------------------------------------------------+
       +-+-> FROM identifier-ansi-style -+---> ;
         +-> PUBLIC ---------------------+

 Displays information about the users who received a particular
 privilege from a particular user.  This is also the list of
 users who lose a particular privilege when it is taken away from
 any users who granted the privilege.

 You can specify a list of tables, columns, or schema but you
 must specify at least one item to display a table, column, or
 schema list.

 For lists of privileges, see the column_privs, schema_privs, and
 table_privs subtopics of the Help topic for GRANT_ANSI_style.

Additional information available:

FROM

 Specifies the identifiers for the new or modified access
 privilege set entry.  Specifying PUBLIC is equivalent to using
 the user identification code (UIC) identifier [*,*].

 show-views =
 --+----->-----+-> VIEWS -+--------------->--------------+-+
   +-> SYSTEM -+          +-> ( -+-+-> COLUMNS -+-+-> ) -+ |
   +-> ALL ----+                 | +-> COMMENT -+ |        |
                                 | +-> SOURCE --+ |        |
                                 +------ , <------+        |
  +------------------------------<-------------------------+
  +--+-+------------>---------+-+-->
     | +-+------>------+-> * -+ |
     | | +-> auth-id. -+      | |
     | +-> view-name ---------+ |
     +---------, <--------------+

 Displays information about views.  If you do not specify a
 wildcard or list of view names, SQL displays the names of all
 the views in all declared schemas.

 If you do not specify any of the SHOW VIEWS options (COLUMNS,
 COMMENT, or SOURCE), by default you will see the display for all
 of these options.

Additional information available:

COLUMNSCOMMENTSOURCE

 Displays each column name, data type, and domain name for the
 specified views.

 Displays the comments for the specified views.

 Displays the source definitions for the specified views.