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

SQL>
For more information, see “Showing the Tables in a Schema” (page 50).
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 TIMING Command
The SHOW TIMING command displays whether the setting for the elapsed time is ON or OFF.
Syntax
SHOW TIMING
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 displays the elapsed time information because the SET TIMING command
is enabled:
SQL>set timing on
SQL>show time
TIME OFF
Elapsed :00:00:00.000
SHOW VIEWS Command
The SHOW VIEWS command displays all or a set of the views that exist in the current schema
of the NCI session.
Syntax
SHOW VIEWS [wild-card-pattern]
146 NCI Commands