Neoview Script Guide (R2.2)

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 60).
SHOW TIME Command
The SHOW TIME command displays whether the setting for the local time in the interface prompt
is ON or OFF.
Syntax
SHOW TIME
Considerations
In the Neoview Script interface, you must enter the command on one line. The command does
not require an SQL terminator.
Example
This command shows that the setting for the local time in the SQL prompt is OFF:
SQL>show time
TIME OFF
SHOW TIMING Command
The SHOW TIMING command displays whether the setting for the elapsed time is ON or OFF.
SHOW TIME Command 135