SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)

Considerations
• You must enter the command in one line.
• If you do not specify a wildcard pattern in a show tables command, RMXCI displays all
the tables that exist in the current schema.
• If you specify a wildcard pattern in a show tables command, RMXCI displays only the table
names that match the wildcard pattern.
• If the set timing command is set to on, the elapsed time information appears.
Examples
• The following 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>
• The following 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 38).
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 in one line.
• If the set timing command is set to on, the elapsed time information appears.
Example
The following 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 to display the elapsed time is on or
off.
SHOW TIME command 113