SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

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 59).
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.
Syntax
SHOW TIMING
Considerations
• You must enter the command in one line.
• If the set timing command is set to on, the elapsed time information appears.
136 RMXCI commands