HP (Hewlett-Packard) 544530-001 Manuel D’Utilisation

SQL>

For more information, see the

Showing the Views in a Schema

The SHOW VIEWS command displays the views that exist in the current schema. For example,
this SHOW VIEWS command displays all the views in the current schema, INVENT:

SQL>set schema invent;

--- SQL operation complete.

SQL>show schema
SCHEMA INVENT

SQL>show views

VIEW NAMES
----------------------------------------------------------------
VIEW207   VIEW207N  VIEWCS    VIEWCUST  

SQL>

For more information, see the

.

The SHOW MVS command displays the materialized views that exist in the current schema. For
example, this SHOW MVS command displays all the materialized views in the current schema,
PERSNL:

SQL>set schema persnl;

--- SQL operation complete.

SQL>show schema
SCHEMA PERSNL

SQL>show mvs;

MATERIALIZED VIEW NAMES
-------------------------------------------------------------
mvemp1  mvemp2  mvemp3  mvjobdesc

SQL>

For more information, see the

.

Showing the Synonyms in a Schema

The SHOW SYNONYMS command displays the synonyms that exist in the current schema. For
example, this SHOW SYNONYMS command displays all the synonyms in the current schema,
SALES:

SQL>set schema sales;

--- SQL operation complete.

SQL>show schema
SCHEMA SALES

SQL>show synonyms

SYNONYM NAMES
-------------------------------------------------------------
CUST  DTLS  ORDR  PRTS  

SQL>

Using Neoview Script Interface Commands

57