HP (Hewlett-Packard) 544530-001 Manual Do Utilizador
•
•
Showing the Schemas
The SHOW SCHEMAS command displays the schemas that exist in the default catalog:
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
-----------------------------------------------------------------------------
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
Showing the Tables in a Schema
The SHOW TABLES command displays the tables that exist in the current schema. For example,
this SHOW TABLES command displays all the tables in the current schema, PERSNL:
this SHOW TABLES command displays all the tables in the current schema, PERSNL:
SQL>show schema
SCHEMA PERSNL
SCHEMA PERSNL
SQL>show tables
TABLE NAMES
----------------------------------------------------------------
DEPT EMPLOYEE JOB PROJECT
----------------------------------------------------------------
DEPT EMPLOYEE JOB PROJECT
SQL>
For more information, see the
.
Showing the Dependent Objects of a Table
The SHOW TABLE command displays information about the indexes, materialized views, or
synonyms of a specified table. For example, this SHOW TABLE command with the INDEXES
option displays information about each index of the EMPLOYEE table:
synonyms of a specified table. For example, this SHOW TABLE command with the INDEXES
option displays information about each index of the EMPLOYEE table:
SQL>show table persnl.employee, indexes
COLUMN NAME ORDER INDEX TYPE UNIQUE CARDINALITY POSITION
------------------------------- ----- ---------- ------ ----------- --------
------------------------------- ----- ---------- ------ ----------- --------
Index 1 :EMPLOYEE
-----------------
EMPNUM ASC Other Yes 0 1
-----------------
EMPNUM ASC Other Yes 0 1
Index 2 :XEMPDEPT
-----------------
DEPTNUM ASC Other No 0 1
-----------------
DEPTNUM ASC Other No 0 1
Index 3 :XEMPNAME
-----------------
LAST_NAME ASC Other No 0 1
FIRST_NAME ASC Other No 0 2
-----------------
LAST_NAME ASC Other No 0 1
FIRST_NAME ASC Other No 0 2
56
Running Commands Interactively in the Neoview Script Interface