1> drop qq_emp 
     
     

  2> create table qq_emp ( 
     id integer4 not null with default,
     dnum char(4) not null with default,
     fname varchar(15) not null with default,
     lname varchar(15) not null with default,
     salary money not null with default,
     sdate date not null with default 
     )
     with noduplicates 
     
     

  3> modify qq_emp to truncated 
     
     

(0 rows)
  4> modify qq_emp to isam on id 
     
     

(0 rows)
  5> create index xqq_emp on qq_emp (id) 
     
     

(0 rows)
  6> help qq_emp 
     
     

Name:                 qq_emp
Owner:                msadmin
Created:              08-oct-2005 12:21:12     
Type:                 user table
Version:              ING6.0  

Column Information:
                                                                  Key
Column Name                      Type       Length Nulls Defaults Seq
id                               integer         4   no     yes     1
dnum                             char            4   no     yes   
fname                            varchar        15   no     yes   
lname                            varchar        15   no     yes   
salary                           money               no     yes   
sdate                            date                no     yes   




  7> help xqq_emp 
     
     

Name:                 xqq_emp
Owner:                msadmin
Created:              08-oct-2005 12:21:13     
Type:                 secondary index
Version:              ING6.0  

Column Information:
                                                                  Key
Column Name                      Type       Length Nulls Defaults Seq
id                               integer         4   no     yes     1
tidp                             integer         4   no     yes     2




  8> commit 
     
     

End of Request