MX Release 3.1 (H06.23+, J06.12+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

For more information, see the “SET LIST_COUNT command” (page 87) and the “SHOW

LIST_COUNT command” (page 104).

Showing information about SQL database objects

• “Showing the schemas” (page 38)

• “Showing the tables in a schema” (page 38)

• “Showing the dependent objects of a table” (page 38)

• “Showing the views in a schema” (page 38)

Showing the schemas

The show schemas command displays the schemas that exist in the current catalog. The following

is a sample output:

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>

For more information, see the “SHOW SCHEMAS command” (page 108).

Showing the tables in a schema

The show tables command displays the tables that exist in the current catalog and schema. For

example, the following command displays all the tables in the catalog CAT1 and schema, PERSNL:

SQL>show catalog

CATALOG CAT1

SQL>show schema

SCHEMA PERSNL

SQL>show tables

TABLE NAMES

----------------------------------------------------------------

DEPT EMPLOYEE JOB PROJECT

For more information, see the “SHOW TABLES command” (page 112).

Showing the dependent objects of a table

The showddl command displays information about the columns , indexes, and other objects such

as triggers, for a specified table. For more information about the showddl command, see the

SQL/MX Release 3.x Reference Manual.

Showing the views in a schema

The show views command displays the views that exist in the current catalog and schema. For

example, the following command displays all the views in the current catalog CAT1, and schema

INVENT:

38 Interactively running commands in RMXCI