% | 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 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. |
|
|
Considerations
•In the Neoview Script interface, 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
•If you specify a
Examples
•This 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 |
DEMOSCH1 | DEMOSCH2 | DEMO_SCH |
DEV060525 | DS_SCH | D_SALES |
HMGR | HPNVS | HPNVSSCH |
HPNVS_SAMPLE | HPNVS_SAMPLE | INVENT |
ODBC_INVENT | ODBC_PERSNL | ODBC_SALES |
ODBC_SCHEMA | ODBC_TEST | PERSNL |
PUBLIC_ACCESS_SCHEMA | ROLEDBA | ROLEMGR |
ROLEUSER | SALES | SCH |
SERVICES | T4JDBC_SCHEMA | TEST1 |
USR |
|
|
SQL>
•This command shows the schemas in the default catalog that have “SALES” in their names:
SQL>show schemas %sales%
SCHEMA NAMES
DBSCRIPT_SALES | D_SALES | ODBC_SALES |
SALES |
|
|
SQL> |
|
|
For more information, see “Showing the Schemas” (page 56).
SHOW SCHEMAS Command 121