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

Index 2 :XEMPDEPT

-----------------

DEPTNUM ASC Other No 0 1

Index 3 :XEMPNAME1

-----------------

LAST_NAME ASC Other No 0 1

FIRST_NAME ASC Other No 0 2

SQL>

• This command shows information about the materialized views of the CUSTOMERS table:

SQL>show table customers, mvs

MATERIALIZED VIEW NAME

----------------------

MYSCH.MV_CUST

SQL>

• This command shows information about the synonyms of the CHANNELS table:

SQL>show table channels, synonyms

SYNONYM NAME

---------------

MYSCH.BANDS

SQL>

• This command shows all information of the EMP table:

SQL>show table employee, all

INDEXES

------------------- ----- ---------- ------ ----------- --------

COLUMN NAME ORDER INDEX TYPE UNIQUE CARDINALITY POSITION

------------------- ----- ---------- ------ ----------- --------

Index 1 :EMPLOYEE

-----------------

EMPNUM ASC Other Yes 0 1

Index 2 :EMPLOYE0

-----------------

DEPTNUM ASC Other No 0 1

Index 3 :EMPLOYE1

-----------------

REQNUM ASC Other No 0 1

BRANKNUM ASC Other No 0 2

No synonyms present for object, SCH.EMPLOYEE

No materialized views present for object, SCH.EMPLOYEE

For more information, see “Showing the Dependent Objects of a Table” (page 56).

SHOW TABLES Command

The SHOW TABLES command displays all or a set of the tables that exist in the current schema

of the Neoview Script session.

Syntax

SHOW TABLES [wild-card-pattern]

SHOW TABLES Command 127

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

Comentários a estes Manuais

Sem comentários

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

Comentários a estes Manuais

Manuais e produtos relacionados com Software HP NEOVIEW 544530-001