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

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 current schema of the session is PERSNL:
SQL>show schema
SCHEMA PERSNL
For more information, see “Setting and showing the current schema” (page 58).
SHOW SCHEMAS command
The show schemas command displays all or a set of schemas that exist in the default catalog of
the current RMXCI session.
Syntax
SHOW SCHEMAS [wild-card-pattern]
wild-card-pattern
is a character string used to search for and display schemas with names that match the character
string. wild-card-pattern matches an uppercase string unless you enclose it within double
quotes. To look for similar values, specify only part of the characters of wild-card-pattern
combined with these wild-card characters:
Use a percent sign (%) to indicate zero or more characters of any type. For example, %art% matches
SMART, ARTIFICIAL, and PARTICULAR but not smart or Hearts. "%art%" matches smart and
Hearts but not SMART, ARTIFICIAL, or PARTICULAR.
%
Use an asterisk (*) to indicate zero or more characters of any type. For example, *art* matches
SMART, ARTIFICIAL, and PARTICULAR but not smart or Hearts. "*art*" matches smart and
Hearts but not SMART, ARTIFICIAL, or PARTICULAR.
*
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 in one line.
• If you do not specify a wildcard pattern in a show schemas command, RMXCI displays all
the schemas that exist in the default catalog.
• If you specify a wildcard pattern in a show schemas command, RMXCI displays only the
schema names that match the wild-card pattern.
• If the set timing command is set to on, the elapsed time information appears.
Examples
• The following command shows all the schemas that exist in the default catalog of the current
session:
SQL>show schemas
SCHEMA NAMES
------------------------------------------------------------------------
DBA001 DBA082 DBMGR
DBSCRIPT_SALES DEFINITION_SCHEMA_VERSION_1200 DEMOSCH
SHOW SCHEMAS command 131