23 lines
606 B
SQL
23 lines
606 B
SQL
{ TABLE "informix".adtb00021 row size = 94 number of columns = 12 index size = 21 }
|
|
create table "informix".adtb00021
|
|
(
|
|
num_emp smallint,
|
|
cod_par smallint,
|
|
sec_par smallint,
|
|
nombre char(30),
|
|
cedula char(20),
|
|
sexo char(1),
|
|
fecha_nac date,
|
|
status_t char(1),
|
|
us_crea char(9),
|
|
fech_crea datetime year to minute,
|
|
us_mod char(9),
|
|
fech_mod datetime year to minute
|
|
);
|
|
revoke all on "informix".adtb00021 from "public";
|
|
|
|
create index "informix".ad21_1 on "informix".adtb00021 (num_emp);
|
|
create index "informix".ad21_2 on "informix".adtb00021 (cod_par,sec_par);
|
|
|
|
|