Displays information about the database and database elements.

Additional information available:

ALLCOLLATING_SEQUENCECONSTRAINTSDATABASES
DATE_FORMATDICTIONARYFIELDSINDEXESLANGUAGE
PRIVILEGESPROTECTIONRADIX_POINTRELATIONS
STORAGE_AREASTORAGE_MAPSTREAMSTRANSACTION
TRANSFERTRIGGERSVERSIONS

 SHOW ALL ────┬──────────────────────────────┬───>
              ├───> 
I
N ─┬─> db-handle ────┬──┤
              │         └────── , <───────┘  │
              └───> 
I
N 
A
L
L 
D
A
T
A
B
A
S
E
S ────────┘

 Shows all the current information about the currently invoked
 databases.

 You must have the Rdb/VMS READ privilege to the database to use the
 SHOW ALL statement.

 SHOW COLLATINGSEQUENCE ──┬───────────────────┬──>
                           └─> sequence-name ──┘

 Displays the collating sequences for databases and fields.

 You can specify the name of the collating sequence you wish to
 display.

 You must have the Rdb/VMS READ privilege to the database to use the
 SHOW COLLATING_SEQUENCE statement.

 SHOW CONSTRAINTS ───────────────────────────────>────────────────┐
  ┌─────────────────────────<─────────────────────────────────────┘
  └────┬─────────────────────────────────────────>──────────────┬─┐
       ├──> 
A
L
L ─────────────────────────────────>──────────────┤ │
       ├──> 
S
Y
S
T
E
M ──────────────────────────────>──────────────┤ │
       ├──> 
U
S
E
R ────────────────────────────────>──────────────┤ │
       ├──┬──> name ────┬────────────────────────>──────────────┤ │
       │  └───── , <────┘                                       │ │
       └──>  
F
O
R ───────┬──┬─> relation-name ──┬─┬──────────────┘ │
                        │  └─> view-name ──────┘ │                │
                        └───────────── , ────<───┘                │
                                                                  │
        ┌─────────────────────────<───────────────────────────────┘
        │
        └──┬───────────────>───────────┬─────────────>
           ├──> 
I
N ─┬─> db-handle ──┬──┤
           │        └────── , <─────┘  │
           └──> 
I
N 
A
L
L 
D
A
T
A
B
A
S
E
S ──────┘

 Lists the names and definitions of constraints.

 You must have the Rdb/VMS READ privilege for the database to use the
 SHOW CONSTRAINTS statement.

 SHOW DATABASES ───┬───────────────────┬───>
                   ├──> 
A
L
L ───────────┤
                   └──┬──> db-name ──┬─┘
                      └─────── , <───┘

 Shows the currently invoked database file names, with their
 associated database handles.  SHOW DATABASES ALL displays the path
 name of all databases defined at the current directory in the data
 dictionary.  You do not have to invoke a database before you use the
 SHOW DATABASES ALL statement.

 You must have the Rdb/VMS READ privilege for a database to display
 information about the database with the SHOW DATABASE statement.

 SHOW DATEFORMAT ───>

 Displays the value for the date-number argument of the SET
 DATE_FORMAT statement.

 You can use the SHOW DATE_FORMAT statement without invoking a
 database, so you do not need any special Rdb/VMS privileges to use
 the statement.

 SHOW DICTIONARY ────>

 Shows the current default directory in the data dictionary.

 You can use the SHOW DICTIONARY statement without invoking a
 database, so you do not need any special Rdb/VMS privileges to use
 the statement.

 SHOW FIELDS  ───────────────────────────────────>────────────────┐
  ┌─────────────────────────<─────────────────────────────────────┘
  └────┬─────────────────────────────────────────>──────────────┬─┐
       ├──> 
A
L
L ─────────────────────────────────>──────────────┤ │
       ├──> 
S
Y
S
T
E
M ──────────────────────────────>──────────────┤ │
       ├──> 
U
S
E
R ────────────────────────────────>──────────────┤ │
       ├──┬──> name ────┬────────────────────────>──────────────┤ │
       │  └───── , <────┘                                       │ │
       └──┬─────────────┬─> 
F
O
R ───┬──┬─> relation-name ──┬─┬─>─┘ │
          └┬─> name ───┬┘          │  └─> view-name ──────┘ │     │
           └──── , <───┘           └───────────── , ────<───┘     │
                                                                  │
        ┌─────────────────────────<───────────────────────────────┘
        │
        └──┬───────────────>───────────┬─────────────>
           ├──> 
I
N ─┬─> db-handle ──┬──┤
           │        └────── , <─────┘  │
           └──> 
I
N 
A
L
L 
D
A
T
A
B
A
S
E
S ──────┘

 SHOW FIELDS lists the globally defined fields and their attributes.

 SHOW FIELDS FOR relation-name lists the local names of the fields and
 their locally defined attributes within the relation.

 You must have the Rdb/VMS READ privilege for a database to display
 information about a field with the SHOW FIELDS statement.

 SHOW INDEXES ───────────────────>────────────────┐
  ┌─────────────────────────<─────────────────────┘
  └────┬─────────────────────────>──────────────┬─┐
       ├──> 
A
L
L ─────────────────>──────────────┤ │
       ├──> 
S
Y
S
T
E
M ──────────────>──────────────┤ │
       ├──> 
U
S
E
R ────────────────>──────────────┤ │
       ├──┬──> name ────┬────────>──────────────┤ │
       │  └───── , <────┘                       │ │
       └──> 
F
O
R ───┬────> relation-name ─────┬──┘ │
                   └───────────── , ────<────┘    │
       ┌────────────────<───────────────────<─────┘
       └───┬───────────────>───────────┬─────────────>
           ├──> 
I
N ─┬─> db-handle ──┬──┤
           │        └────── , <─────┘  │
           └──> 
I
N 
A
L
L 
D
A
T
A
B
A
S
E
S ──────┘
 Shows the names and definitions of indexes.

 To use the SHOW INDEXES statement to display information about an
 index, you must have the Rdb/VMS READ privilege for the database.

 SHOW LANGUAGE ───>

 Displays the language that will be used for date and time input and
 display.

 You can use the SHOW LANGUAGE statement without invoking a database,
 so you do not need any special Rdb/VMS privileges to use the
 statement.

 SHOW PRIVILEGES FOR  ────┐
      ┌───<───────────────┘
      └────┬───> 
D
A
T
A
B
A
S
E ───────────>─────────────────┬───>
           ├───> 
R
E
L
A
T
I
O
N ──> relation-name ───────────┤
           ├───> 
V
I
E
W ──────> view-name ───────────────┤
           └───> 
F
I
E
L
D ─> field-name IN relation-name ─┘

 Displays your access control list (ACL) entry when Rdb/VMS matches
 your UIC with the identifier specified in the ACL entry (ACE).
 Although your UIC may match many ACL entries, Rdb/VMS stops when it
 finds the first match and grants you those access rights.

 You can display your particular privileges for the database, a
 relation, or a view.  Note the difference between the SHOW PRIVILEGES
 and SHOW PROTECTION statements.  The SHOW PROTECTION statement
 displays all ACL entries.  The SHOW PRIVILEGES statement displays
 only your ACE or the privileges you have to a database object as a
 result of holding one or more of the VMS or Rdb/VMS overriding
 privileges.

 You must have the Rdb/VMS READ privilege for a database to use the
 SHOW PRIVILEGES statement.

Additional information available:

More

 You must invoke a database before you issue the SHOW PRIVILEGES
 statement.

 The display for the SHOW PRIVILEGES statement reflects information
 stored following a COMMIT or ROLLBACK statement and a detach from the
 database with a FINISH statement.  Unlike the SHOW PROTECTION
 statement, SHOW PRIVILEGES will not reflect uncommitted changes.  Any
 changes you make to your privileges or those of other users do not
 take effect until you detach from the database.

 In order to perform a certain operations, you must have the correct
 access mode privilege (READ, WRITE, MODIFY, or ERASE) on both the
 database and the relation.  Therefore, the SHOW PRIVILEGES display
 for a relation will drop any access mode privileges that are not
 present for the database before displaying the privileges for the
 relation.

 If you hold one or more of the VMS override privileges (SYSPRV, OPER,
 or SECURITY) or one or more of the Rdb/VMS role-oriented privileges
 (ADMINISTRATOR, OPERATOR, or SECURITY), you are implicitly granted
 privileges to database objects as a result of an ACL override.  You
 operate as if you actually hold the privileges you are implictly
 granted, even though these privileges are not stored in the ACL.  The
 SHOW PRIVILEGES statement displays the privileges you have to a
 database object as a result of holding the VMS override privilege or
 Rdb/VMS role-oriented privilege.

 The SHOW PRIVILEGES statement displays only those privileges that are
 valid for the database object.  For example, although you may hold
 the Rdb/VMS ADMINISTRATOR, OPERATOR, or SECURITY database privileges,
 these privileges are not displayed when you issue the SHOW PRIVILEGES
 statement for a relation because they are not relation privileges.

 SHOW PROTECTION FOR  ────┐
 ┌────────────<───────────┘
 └─┬───> 
D
A
T
A
B
A
S
E ───────────>─────────────────┬───>
   ├───> 
R
E
L
A
T
I
O
N ──> relation-name ───────────┤
   ├───> 
V
I
E
W ──────> view-name ───────────────┤
   └───> 
F
I
E
L
D ─> field-name IN relation-name ─┘

 Displays the access control list for the named database, relation,
 field or view.

 To use the SHOW PROTECTION statement to display the protection for a
 database, relation, view, or field, you must have the Rdb/VMS READ
 privilege to the database.

 SHOW RADIXPOINT ──>

 Displays the character that will be used as the radix point in output
 displays.

 The radix point is the symbol that separates units from decimal
 fractions.  For example, in the number 98.6, the period is the radix
 point.

 You can use the SHOW RADIX_POINT statement without invoking a
 database, so you do not need any special Rdb/VMS privileges to use
 the statement.

 SHOW RELATIONS ─┬────────────┬─┬─────────────────────────┬─>
                 ├─> 
A
L
L ─────┤ ├─> 
I
N ──┬─> db-handle ──┬┤
                 ├─> 
S
Y
S
T
E
M ──┤ │        └─────── , <────┘│
                 ├─> 
U
S
E
R ────┤ └─> 
I
N 
A
L
L 
D
A
T
A
B
A
S
E
S ─────┘
                 └─┬─> name ─┬┘
                   └──── , <─┘

 Lists the names of the relations and the relation-specific
 constraints.

 You must have the Rdb/VMS READ privilege for the database to use the
 SHOW RELATIONS statement.

 SHOW STORAGE AREAS ────────────────┐
 ┌───────────────────────<──────────┘
 └─┬──────────────>──────────────┬──┐
   ├────> 
A
L
L ────────>──────────┤  │
   └──┬─> storage-area-name ──┬──┘  │
      └──────<───── , <───────┘     │
 ┌────────────────────<─────────────┘
 └─┬───────────────────>──────────┬───>
   ├───> 
I
N ───────> db-handle ───┤
   └───> 
I
N 
A
L
L 
D
A
T
A
B
A
S
E
S ────────┘

 Displays the names of all storage areas for the currently invoked
 database, for a specific database, or for all invoked databases.  If
 you specify a storage area name, the statement displays the following
 information about the storage area:


  o  Page format

  o  Identification of read-only areas

  o  Page size

  o  Storage file specification

  o  Storage file allocation, minimum extent, maximum extent, and
     percent growth

  o  Snapshot file specification

  o  Snapshot file allocation, minimum extent, maximum extent, and
     percent growth


 You must have the Rdb/VMS READ privilege for a database to use the
 SHOW STORAGE AREAS statement.

 SHOW STORAGE MAPS ──────────────────┐
  ┌────────────────<─────────────────┘
  └─┬────────────────────────>─────────────────────┬─┐
    ├──> 
A
L
L ────────────────>─────────────────────┤ │
    ├──┬──> name ────┬───────>─────────────────────┤ │
    │  └───── , <────┘                             │ │
    └──┬──────>────┬─> 
F
O
R ──┬─> relation-name ─┬──┘ │
       └┬─> name ─┬┘         └────────── , ─────┘    │
        └──── , <─┘                                  │
     ┌───────────────────────<───────────────────────┘
     └──┬───────────────>───────────┬─────────────>
        ├──> 
I
N ─┬─> db-handle ──┬──┤
        │        └────── , <─────┘  │
        └──> 
I
N 
A
L
L 
D
A
T
A
B
A
S
E
S ──────┘

 Displays information about storage maps.

 You must have the Rdb/VMS READ privilege for the database to display
 the relation's storage map with the SHOW STORAGE MAPS statement.

 SHOW STREAMS ───┬──────────────────────────────┬──>
                 ├──> 
I
N ──┬──> db-handle ───┬──┤
                 │         └─────── , <──────┘  │
                 └──> 
I
N 
A
L
L 
D
A
T
A
B
A
S
E
S ─────────┘

 Identifies the streams that are currently open.

 You must have the Rdb/VMS READ privilege to the database to use the
 SHOW STREAMS statement.

 SHOW TRANSACTION ───>

 Displays information about the transaction mode, transaction id
 (TID), transaction sequence number (TSN), and, for read/write
 transactions, the status of updates and the full recovery-unit
 journal (RUJ) file specification.  The SHOW TRANSACTION statement
 also shows whether or not fast commit is enabled.

 You must have the Rdb/VMS READ privilege for a database to use the
 SHOW TRANSACTION statement.

 The following START_TRANSACTION statement starts a read/write
 transaction reserving the EMPLOYEES table for shared read.  Note that
 the SHOW TRANSACTION statement shows that fast commit is enabled for
 the database.

 RDO> START_TRANSACTION READ_WRITE RESERVING
 cont> EMPLOYEES FOR SHARED READ
 RDO> SHOW TRANSACTION
 All Transactions in Database with filename MF_PERSONNEL
 a read-write transaction is in progress
   - updates have not been performed
   - fast commit is enabled
   - transaction sequence number (TSN) is 121
   - snapshot space for TSNs less than 121 can be reclaimed
   - session ID number is 42

 [VAX Data Distributor]

 To get HELP on the SHOW TRANSFER statement, see the entry for
 SHOW_TRANSFER under the main topic Data_Distrib.

 SHOW TRIGGERS ───>────────────────────────┐
  ┌────────────────────────────────────────┘
  └───────┬───────────────>────────────┬─┐
          ├───> 
A
L
L ───────────────────┤ │
          ├───> 
S
Y
S
T
E
M  ───────────────┤ │
          ├───> 
U
S
E
R  ─────────────────┤ │
          ├┬──> trigger-name ─┬────────┤ │
          │└───── , <─────────┘        │ │
          └─> 
F
O
R ─┬─> relation-name ─┬┘ │
                   └───────── , <─────┘  │
  ┌─────────────────────<────────────────┘
  └─┬────>─────────────────────┬─────────────>
    └─> 
I
N ─┬─ 
A
L
L 
D
A
T
A
B
A
S
E
S ─┬┘
            └┬─ db-handle ──┬─┘
             └───── , <─────┘

 Displays trigger names and definitions of the specified triggers for
 a specified database or all invoked databases.

 To display information about a trigger for a relation using the SHOW
 TRIGGER command, you must have the Rdb/VMS READ privilege for the
 database.

 SHOW VERSIONS ───>

 Displays all versions of the Rdb/VMS components you are running.

 You can use the SHOW VERSIONS statement without invoking a database,
 so you do not need any special Rdb/VMS privileges to use the
 statement.