Neoview Script Guide (R2.2)

Examples
• This command shows all the synonyms in the current schema, SALES:
SQL>show synonyms
SYNONYM NAMES
-------------------------------------------------------------
CUST DTLS ORDR PRTS
SQL>
• This command shows all the synonyms in the current schema, SALES, that have “S” at the
end of their names:
SQL>show synonyms %s
SYNONYM NAMES
-------------------------------------------------------------
DTLS PRTS
SQL>
• This command shows all the synonyms in the current schema, SALES, that are named “PRT”
followed by one character:
SQL>show synonyms "PRT_"
SYNONYM NAMES
-------------------------------------------------------------
PRTS
SQL>
SHOW TABLE Command
The SHOW TABLE command displays information about the indexes, materialized views, or
synonyms of a specified table or materialized view.
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.
132 Neoview Script Interface Commands