----------  Display  ----------

This command displays information about a database, a table, table privilege,
a database role, a schema, a module or a sequence. There are several forms.

Syntax:

1) display |database| [DATABASE] [on [table] |TABLE_NAME            |]
           |db      |                        |[not] MATCH_OP PATTERN|

         [all] [dump] [| into | FILE ];
                       | onto |

If DATABASE is specified, the tables in that database are displayed.  If DATA-
BASE is not specified, then the current database is assumed and its tables are
displayed.  The keyword "all" may be used to display the actual definition  of
every table in the database, including the trigger information on the table.

Syntax:

2) display TABLE [on [attr] |ATTR_NAME             |]
                            |[not] MATCH_OP PATTERN|

        [all] [dump] [| into | FILE];
                      | onto |

This displays the structure of the table TABLE.  The  output  of  the  command
"display TABLE dump into FILE;" is entirely compatible with the input required
by the command "create TABLE from FILE;".

For either variation, the keyword "dump"  can be used to produce output  in  a
manner more suitable for further processing than the straight display.

The output of a display command may be redirected from the terminal into a new
file  or  appended to an existing file by specifying "into" or "onto", respec-
tively, and a filename.

With the keyword "all", if there is any trigger on the table, the trigger 
information will be displayed.

Syntax:

3) display grant |privilege| TABLE [on [attr] |ATTR_NAME             |]
                 |priv     |                  |[not] MATCH_OP PATTERN|

        [|all          |];
         |as |dba     ||
             |creator ||
             |USERNAME||

This displays grant options on the access privileges to the table.

Syntax:

4) display |privilege| TABLE [on [attr] |ATTR_NAME             |]
           |priv     |                  |[not] MATCH_OP PATTERN|

        [|all          |];
         |as |dba     ||
             |creator ||
             |USERNAME||
This displays access privileges to the table.

For further information, enter:

                help create_table;
                help privilege;

Syntax:

5) display role [ROLE] [all] [| into | FILE];
                              | onto |

This displays database role[s] in a database, if ROLE is not specified, the
information on all database roles will be displayed. More details can be
displayed with keyword "all". 

The output of a display command may be redirected from the terminal into a new
file  or  appended to an existing file by specifying "into" or "onto", respec-
tively, and a filename.

For further information, enter:
                help role;

Syntax:

6) display schema [SCHEMA] [all] [dump] [| into | FILE];
                                         | onto |
This displays schema information in a database, if SCHEMA is not specified,
the information on all schemas will be displayed. More details can be obtained
with keyword "all", the keyword "dump"  can be used to produce output  in  a
manner more suitable for further processing than the straight display.

The output of a display command may be redirected from the terminal into a new
file  or  appended to an existing file by specifying "into" or "onto", respec-
tively, and a filename.

For further information, enter:

                help schema;

7) display module [MODULE] [all] [dump] [| into | FILE];
                                         | onto |
This displays module information in a database, if MODULE is not specified,
the information on all modules will be displayed. More details can be obtained
with keyword "all", the keyword "dump"  can be used to produce output  in  a
manner more suitable for further processing than the straight display.

The output of a display command may be redirected from the terminal into a new
file  or  appended to an existing file by specifying "into" or "onto", respec-
tively, and a filename.

For further information, enter:

                help module;

8) display sequence [SEQUENCE] [all] [dump] [| into | FILE];
                                             | onto |
This displays sequence information in a database, if SEQUENCE is not specified,
the information on all sequences will be displayed. More details can be obtained
with keyword "all", the keyword "dump"  can be used to produce output  in  a
manner more suitable for further processing than the straight display.

The output of a display command may be redirected from the terminal into a new
file  or  appended to an existing file by specifying "into" or "onto", respec-
tively, and a filename.

For further information, enter:

                help sequence;

