. 3, , C++Builder 3.0,  "/"  Internet
2,2.2    ,    
       SQL Explorer       . ,   Indices  ,     , ,    ,     (. 2.7).
 SQL Explorer
      C++Builder 3.0
Object   Dictionary   Edit   View	Oo.tions   Help
:..  .-            J^                  "    -:i          (^	,^_,        .;,>          'i'              '               *
I All Database Aliases	; Definition of EMPNO
   +   -   *
Databases | Dictionary)	Definition ] Text      Enter SQL |
,; INTRBASE1                                       _>J	Order                                      ,1
J Domains	Column                                       1                j^j:
" Tables	
j-B DEPT	
3 >B EMP	
3 [| Columns	
!     ~B EMPNO	
i    S ) ENAME	
] a- a JOB	
I     MGR	
i    ~ HIREDATE                      	
i    - SAL	
; - 	
I    ffl-B DEPTNO	I
  ^(| Indices	I
i    $ EMPINDEX1	
!     ;    E :^' Columns	j  :
;     '-.^	
|    B-B PK_EMP	| I
:         -- Columns	
;          ;-- EMPNO	j
|] Primary Key	
   |] Referential Constraints	\
:   [1 Unique Constraints	
1 Check Constraints                    ''I	
<1                              1    H	
................... ........... ............ ..............	
Puc. 2.7.     SQL Explorer
      Apply,   .            SQL Explorer  Text,     SQL:	" . -.-.
CREATE ASCENDING INDEX EMPINDEX1 ON EMP (MGR)
To        Oracle:
CREATE  INDEX USER101."EMPIndexl" ON USER101.EMP (MGR)
    ,    Columns    New.              (. 2.8).
SQLExplorei                                                                                          =11		
Object   dictionary   Edit   View   Ogtions   Help		
,.: ><!	-^                 +-1 \'-'   ! "            r   	
All Database Aliases                                      ; Definition of PROJNO                                     d		
Databases	Dictionary)                                  Definition | Text   | Enter SQL)                     	
+       tti Off	SYS. TAB LE_PR IVILE G E_M_-J SYSTEM.LISER_PROFILE	Order                 1 Type               ^NUMBER
i aa	USER101.DEPT	Length           " J~II1
!    ||... |*-	 USER101.EMP	Precision         i
i         -^ Columns		Scale'"         - --"
	|--B EMPNO	Nulls              ..-......
!         j	j  ENAME	Defauit""
	I--B JOB	
:                            i	I--B MGR	
"                 ;	j--B HIREDATE	
	H SAL	
	-  --B DEPTNO ;)!(- ?|^;	
:       '	 Indices	
	B- USERIOl.EMPInde:	
lJ   "^	i    H || Columns            H T;S::S": :-::; J        jj	
		
. 2.8.        SQL Explorer
j:epjepHiix _  ,   New     Tables,     ,   New       (. 2.9).
32
33