SHOW  --+-> show-domains --------------+-->
         +-> show-indexes --------------+
         +-> show-privileges -----------+
         +-> show-schema ---------------+
         +-> show-session-information --+
         +-> show-storage-areas --------+
         +-> show-storage-maps ---------+
         +-> show-tables ---------------+
         +-> show-views ----------------+

Additional information available:

More Informationdomainsindexesprivilegesschemassession information
storage areasstorage mapstablesviews

 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-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-privileges =
 --+-> PRIVILEGES ON -++-> TABLES -+-> table-name  -+------------+->
   +-> PROTECTION ON -+|           +------- , <-----+            |
                       +-> SCHEMAS AUTHORIZATION -+-> auth-id -+-+
                                                  +----- , <---+

 SHOW PRIVILEGES displays only your ACL entry for the specified
 tables or schemas.  SHOW PROTECTION displays all the entries in
 the ACL for the specified tables or schemas.

 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 =
 -+-> DICTIONARY ---+->
  +-> TRANSACTION --+
  +-> VERSIONS -----+
  +-> SQLCA --------+

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

 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 -+           | +-+-------------+-> * -+ |
  +-> ALL ----+           | | +-> 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.

 show-views =
 --+-----------+-> VIEWS -+-+----------------------+-+-->
   +-> SYSTEM -+          | +-+-------------+-> * -+ |
   +-> ALL ----+          | | +-> 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.