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

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 TABLES command, NCI displays all
the tables that exist in the current schema.
• If you specify a wild-card pattern in a SHOW TABLES command, NCI displays only the
table 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 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 64).
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
• You must enter the command on one line. The command does not require an SQL terminator.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Example
This command shows that the setting for the local time in the SQL prompt is OFF:
SQL>show time
TIME OFF
SHOW TIME Command 153