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

SQL>
• This command shows information about the synonyms of the CHANNELS table:
SQL>show table channels, synonyms
SYNONYM NAME
---------------
MYSCH.BANDS
SQL>
• This command shows all information of the EMP table:
SQL>show table employee, all
INDEXES
------------------- ----- ---------- ------ ----------- --------
COLUMN NAME ORDER INDEX TYPE UNIQUE CARDINALITY POSITION
------------------- ----- ---------- ------ ----------- --------
Index 1 :EMPLOYEE
-----------------
EMPNUM ASC Other Yes 0 1
Index 2 :EMPLOYE0
-----------------
DEPTNUM ASC Other No 0 1
Index 3 :EMPLOYE1
-----------------
REQNUM ASC Other No 0 1
BRANKNUM ASC Other No 0 2
No synonyms present for object, SCH.EMPLOYEE
No materialized views present for object, SCH.EMPLOYEE
For more information, see “Showing the Dependent Objects of a Table” (page 64).
SHOW TABLES Command
The SHOW TABLES command displays all or a set of the tables that exist in the current schema
of the NCI session.
Syntax
SHOW TABLES [wild-card-pattern]
wild-card-pattern
is a character string used to search for and display tables 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.
*
152 NCI Commands