HP (Hewlett-Packard) 544530-001 Manuale Utente
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
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.
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:
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
ascending or descending, for rows
in the index
• Order
Type of index (clustered, hashed, or
other)
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
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
index
• Cardinality
Position of the column within the
index
index
• Position
For more information about indexes, see the Neoview SQL
Reference Manual.
Reference Manual.
MVS
displays a list of the materialized views associated with the
specified table or materialized view.
specified table or materialized view.
ALL
displays information about indexes, materialized views, and
synonyms for a specified table or materialized view.
synonyms for a specified table or materialized view.
SYNONYMS
displays a list of the synonyms associated with the specified
table or materialized view.
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.
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
------------------- ----- ---------- ------ ----------- --------
COLUMN NAME ORDER INDEX TYPE UNIQUE CARDINALITY POSITION
------------------- ----- ---------- ------ ----------- --------
Index 1 :EMPLOYEE
-----------------
EMPNUM ASC Other Yes 0 1
-----------------
EMPNUM ASC Other Yes 0 1
126
Neoview Script Interface Commands