SHOW --+-> show-aliases --------------+-->
          +-> show-catalogs -------------+
          +-> show-collating-sequence ---+
          +-> show-connections ----------+
          +-> show-cursors --------------+
          +-> show-databases ------------+
          +-> show-domains --------------+
          +-> show-indexes --------------+
          +-> show-privileges -----------+
          +-> show-query-confirm  -------+
          +-> show query-limit ----------+
          +-> show-schemas --------------+
          +-> 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 Informationaliasescatalogscollating sequencesconnections
cursorsdatabasesdefaultdomainsindexesprivileges or protection
query confirmquery limitschemassession informationstorage areas
storage mapstablestriggersusers grantingusers withviews

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

 show-aliases =

 ---> ALIASES --+--------------+->
                +-+-> alias -+-+
                  +--- , <---+

 An alias is a name for a particular attachment to a database.
 Once you have specified an alias, you must use it when referring
 to the database in subsequent SQL statements, unless those
 statements are within a single CREATE DATABASE statement.

 For each alias, SQL displays the pathname or filename of the
 current default database (Rdb/VMS or VIDA), and the file
 specification for the database file.

 show-catalogs =

 ---> CATALOGS --+-----------------------+--->
                 ++---> catalog-name --+-+
                  +-------- , <--------+

 A catalog is a group of schemas within a multischema database
 For each catalog, SQL displays the pathname, filename or alias
 of the current default database (Rdb/VMS or VIDA), any defined
 collating sequence, and the file specification for the database
 file.  If the catalog was declared using a data dictionary path
 name, SQL also displays that path name.

 If you do not specify any aliases with SHOW CATALOGS, SQL
 displays information about all declared databases.

 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-connections =

 ---> CONNECTIONS --+--------------------------+--->
                    ++---> connection-name --+-+
                     +-------- , <-----------+

 A connection specifies an association between the set of
 cursors, temporary tables, and procedures in all modules of an
 application and the database environment currently attached.
 When you issue a CONNECT statement, SQL creates a new connection
 from all the procedures in your application and creates a new
 database environment for the databases named in the CONNECT
 statement.  Procedures execute in the context of a particular
 connection.  The SHOW CONNECTIONS statement shows the names of
 existing connections.

 show-cursors =

 ---> CURSORS ---+--------------------------+--->
                 ++---> cursor-name ------+-+
                  +-------- , <-----------+

 A cursor lets you specify individual rows of a result table
 specified in the select expression in a DECLARE CURSOR
 statement.  The SHOW CURSORS statement shows the name of each
 cursor, the type of cursor (TABLE or LIST), and the mode of
 operation for the cursor (INSERT ONLY, READ ONLY, or UPDATE).

 show-database =

 --> DATABASES +----------------+-->
               +-+-> alias ---+-+
                 +----- , <---+

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

 show-default =

 SHOW DEFAULT;

 The SHOW DEFAULT statement shows the default schema and catalog
 names.  For example, if user ELLINGSWORTH attached to the sample
 multischema database, he or she would see the following output:

 SQL> ATTACH 'FILENAME CORPORATE_DATA';
 SQL> SHOW DEFAULT
 Default catalog name is RDB$CATALOG
 Default schema name is ELLINGSWORTH

 You can use SET CATALOG and SET SCHEMA statements to change the
 default catalog and schema, respectively.

 show-domains =
 -+-----------+-> DOMAINS -+----------------------------+->
  +-> SYSTEM -+            ++-+-+-------------+-> * -+-++
  +-> ALL ----+             | | +-> alias. ---+      | |
                            | +-> 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 attached databases.

 show-indexes =
 -+-----------+-> INDEXES -+------------------------------+-->
  +-> SYSTEM -+            +-+-+-+-------------+-> * -+-+-+
  +-> ALL ----+            | | | +-> alias. ---+      | | |
                           | | +-> 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 attached databases.

 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 databases, tables, or columns.  SHOW
 PRIVILEGES displays only your access privilege set entry for the
 specified databases, 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-query-confirm  =

 ---> QUERY CONFIRM ------>


 Shows whether the QUERY CONFIRM option is set on.  The SET QUERY
 CONFIRM statement makes SQL display the estimated number of I/O
 operations each query will cost and offers you an opportunity to
 cancel each query instead of executing it.

 show-query-limit  =

 ---> QUERY LIMIT ------>

 Shows whether the QUERY LIMIT option is set on.  The SET QUERY
 LIMIT statement makes SQL display the estimated number of rows
 each query will fetch and offers you an opportunity to cancel
 each query instead of executing it.

 show-schemas =

 --> SCHEMAS -+-----------------+-->
              ++> schema-name -++
               +------> , -----+

 Displays the names of specified schemas.  If you do not specify
 an alias, SQL displays schema information for all of the
 attached databases.

 For each multischema database, SQL displays the alias, followed
 by a list of schemas contained in that database.  Each schema
 name in the list is preceded by the catalog and alias names.

 For each non-multischema database, SQL displays the message "No
 schemas found".  To show database information, use the SHOW
 DATABASE statement.

 show-session-information =

 -+-> ANSI DATE MODE -----------+->
  +-> ANSI IDENTIFIERS MODE ----+
  +-> ANSI QUOTING MODE --------+
  +-> CONSTRAINT MODE ----------+
  +-> CURRENCY SIGN ------------+
  +-> DATE FORMAT --------------+
  +-> DICTIONARY ---------------+
  +-> DIGIT SEPARATOR ----------+
  +-> EXECUTION MODE -----------+
  +-> FLAGGER MODE -------------+
  +-> LANGUAGE -----------------+
  +-> RADIX POINT --------------+
  +-> SQLCA --------------------+
  +-> TRANSACTION --------------+
  +-> VERSIONS -----------------+
  +-> WARNING MODE -------------+

 SHOW ANSI AUTHORIZATION MODE shows whether SQL bases privilege
 checking on the default authorization identifier, in compliance
 with the ANSI/ISO standard.  If the authorization mode is ON,
 SQL restricts any user other than the one who compiled a module
 from invoking that module.

 SHOW ANSI DATE MODE shows whether the default DATE data type is
 set to DATE ANSI or DATE VMS.

 SHOW ANSI RESERVED WORDS MODE shows whether reserved words
 checking is enabled.  You must enclose reserved words from the
 ANSI 89 standard in double quotation marks in order to supply
 them as user-supplied names in SQL statements.  When you enable
 the reserved words mode, SQL issues an informational message
 after statements that misuse reserved words.  For a list of the
 reserved words, see the SQL Reference Manual appendices.

 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 EXECUTION MODE shows whether or not SQL will execute the
 statements that you issue in your interactive SQL session.  The
 default is to execute the statements as you issue them.
 However, if you have issued a SET NOEXECUTE statement in your
 session, SQL will not execute subsequent statements.

 SHOW FLAGGER MODE shows whether or not SQL will flag statements
 containing syntax that does not conform to the ANSI/ISO standard
 for SQL.  If you specify SET FLAGGER ON, SQL sends you an
 informational message if you issue a subsequent interactive SQL
 statement that contains nonstandard syntax.

 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 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 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 WARNING MODE displays the default setting for warning
 messages.  If WARNING MODE is set to ON, SQL flags statements
 containing obsolete SQL syntax.  Obsolete syntax is syntax that
 was allowed in previous versions of SQL but has changed.
 Digital recommends that you avoid using such syntax, because it
 may not be supported in future versions.  By default, SQL
 displays a warning message after any statement containing
 obsolete syntax (WARNING MODE ON).

 To suppress messages about obsolete syntax, use the SET WARNING
 NODEPRECATE statement.

 show-storage-areas =

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

 Displays information about the storage areas for the attached
 databases.  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 ----+                  | | +-> alias. ---+      | |
                                 | +-> storage-map-name --+ |
                                 +----------- , <-----------+

 Displays information about the storage maps for the attached
 databases.  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 -----+ |        |
                                  +--------- , <--------+        |
  +------------------------------<-------------------------------+
  +--+-+----------->----------+-+-->
     | +-+-------------+-> * -+ |
     | | +-> alias. ---+      | |
     | +-> 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 attached databases.

 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 -+-+----------------------+-+-->
                  | +-+-------------+-> * -+ |
                  | | +-> alias. ---+      | |
                  | +-> 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 attached databases.

Additional information available:

table nameschema name

 The name of the table definition you want to show.
 table-name =

 -+------------------------+-> name-of-table --+->
  +-+-> schema-name -+> . -+                   |
  | +-> alias -------+                         |
  +---> " alias.name-of-table " ---------------+

 The name of the schema, which may be used to qualify the table
 name in a multischema database.
 schema-name  =
  -+----------------------------------------+-+
   +------> catalog-name ------------+-> . -+ |
   +-> " -> alias.catalog-name -> " -+        |
   |   +--------------------------------------+
   |   +--------------> name-of-schema --------+->
   +-> " -> alias.name-of-schema -> " ---------+

 show-users-granting =

  -> USERS GRANTING ---+
  +--------------------+
  +-+-> table-privs-ansi --+----------+
    +-> column-privs-ansi -+          |
    +-> db-privs-ansi -----+          |
  +-----------------------------------+
  +-> ON -+-> TABLE  -+-> table-name  -+-+--+
          |           +------- , <-----+ |  |
          +-> COLUMN -+-> column-name -+-+  |
          |           +------- , <-----+ |  |
          +-> DATABASE -+-> alias --+----+  |
                        +---- , <---+       |
       +------------------------------------+
       +---> 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 databases but you
 must specify at least one item to display a table, column, or
 database list.

 For lists of privileges, see the column_privs, db_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 --+----------+
    +-> column-privs-ansi -+          |
    +-> db-privs-ansi -----+          |
  +-----------------------------------+
  +-> ON -+-> TABLE  -+-> table-name  -+-+--+
          |           +------- , <-----+ |  |
          +-> COLUMN -+-> column-name -+-+  |
          |           +------- , <-----+ |  |
          +-> DATABASE -+-> alias --+----+  |
                        +---- , <---+       |
  +-----------------------------------------+
  +-> 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 databases but you
 must specify at least one item to display a table, column, or
 database list.

 For lists of privileges, see the column_privs, db_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 --+ |        |
                                 +------ , <------+        |
  +------------------------------<-------------------------+
  +--+-+------------>---------+-+-->
     | +-+------>------+-> * -+ |
     | | +-> alias. ---+      | |
     | +-> 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 attached databases.

 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.