1> destroy qq_emp 
     

  2> create 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> index on qq_emp is xqq_emp (id) 
     

(0 rows)
  6> help qq_emp 
     

Name:                 qq_emp
Owner:                msadmin
Created:              08-oct-2005 12:18:06     
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:18:07     
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



End of Request