Neoview Command Interface (NCI) Guide (R2.3)

Use an underscore (_) to indicate any single character.
For example, boo_ matches BOOK and BOOT but not
BOO or BOOTS. "boo_" matches book and boot but
not boo or boots.
_
Use a question mark (?) to indicate any single character.
For example, boo? matches BOOK and BOOT but not
BOO or BOOTS. "boo?" matches book and boot but
not boo or boots.
?
Considerations
• 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.
• If you do not specify a wild-card pattern in a SHOW SYNONYMS command, NCI displays
all the synonyms that exist in the current schema.
• If you specify a wild-card pattern in a SHOW SYNONYMS command, NCI displays only
the synonym names that match the wild-card pattern.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
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
146 NCI Commands