Syntax
SHOW TABLE {table-name | materialized-view-name}, { INDEXES | MVS | SYNONYMS |ALL}
table-name is:
[schema-name.]table-name
table-name
specifies the name of a table. If you do not fully qualify the
table-name, Neoview Script uses the current schema.
materialized-view-name
specifies the name of a materialized view. If you do not fully
qualify the materialized-view-name, Neoview Script
uses the current schema.
INDEXES displays information about the indexes associated with the
specified table or materialized view. The displayed
information about each index includes:
Name of each column in the index• Column name
Storage and retrieval order, either
ascending or descending, for rows
in the index
• Order
Type of index (clustered, hashed, or
other)
• Index type
Whether the column or set of
columns that comprise the index do
not contain more than one
occurrence of the same value or set
of values
• Uniqueness
Number of unique values in the
index
• Cardinality
Position of the column within the
index
• Position
For more information about indexes, see the Neoview SQL
Reference Manual.
MVS displays a list of the materialized views associated with the
specified table or materialized view.
ALL displays information about indexes, materialized views, and
synonyms for a specified table or materialized view.
SYNONYMS displays a list of the synonyms associated with the specified
table or materialized view.
Considerations
• In the Neoview Script interface, you must enter the command on one line. The command
does not require an SQL terminator.
• You can execute this command only in SQL mode.
Examples
• This command shows information about three indexes of the EMPLOYEE table:
SQL>show table persnl.employee, indexes
COLUMN NAME ORDER INDEX TYPE UNIQUE CARDINALITY POSITION
------------------- ----- ---------- ------ ----------- --------
Index 1 :EMPLOYEE
-----------------
EMPNUM ASC Other Yes 0 1
126 Neoview Script Interface Commands