Filter
Top Products
SQL>
For more information, see the “SHOW TABLE Command” (page 125).
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 “SHOW VIEWS Command” (page 129).
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 “SHOW MVS Command” (page 117).
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