範例資料表

create table m1(

name character(10),

sex character(2),

age smallint,

tel character(16),

fax character(16),

mobil character(16),

email varchar(60),

address text

);

create index main_ndx on main(name);