wild-card-pattern
is a character string used to search for and display tables with names
that match the character string. wild-card-pattern matches an
uppercase string unless you enclose it within double quotes. To look
for similar values, specify only part of the characters of
wild-card-pattern combined with these wild-card characters:
Use a percent sign to indicate zero or
more characters of any type. For example,
%art% matches SMART, ARTIFICIAL,
and PARTICULAR but not smart or
Hearts. "%art%" matches smart and
Hearts but not SMART, ARTIFICIAL,
or PARTICULAR.
%
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.
_
Considerations
• In the Neoview Script interface, 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 TABLES command, Neoview Script
displays all the tables that exist in the current schema.
• If you specify a wild-card pattern in a SHOW TABLES command, Neoview Script displays
only the table names that match the wild-card pattern.
Examples
• This command shows all the tables in the current schema, PERSNL:
SQL>show schema
SCHEMA PERSNL
SQL>show tables
TABLE NAMES
-------------------------------------------------------------
DEPT EMPLOYEE JOB PROJECT
SQL>
• This command shows the tables in the current schema, INVENT, that have “PART” at the
beginning of their names:
SQL>show tables part%
TABLE NAMES
-------------------------------------------------------------
PARTLOC PARTSUPP
SQL>
For more information, see “Showing the Tables in a Schema” (page 56).
SHOW TIME Command
The SHOW TIME command displays whether the setting for the local time in the interface prompt
is ON or OFF.
128 Neoview Script Interface Commands