HP NEOVIEW 544530-001 Manual do Utilizador descarregar pdf (Página 126)

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

1 2 ... 121 122 123 124 125 126 127 128 129 130 131 ... 141 142

Comentários a estes Manuais

Sem comentários

HP NEOVIEW 544530-001 Manual do Utilizador Página 126

Comentários a estes Manuais

Manuais e produtos relacionados com Software HP NEOVIEW 544530-001