7

sql语句

DROP TABLE lw_bin;
create table lw_bin
(
  XH INTEGER not null generated by default as identity,
  GJ_DM CHAR(3) not null,
  GJ_MC VARCHAR(100) not null,
  GJ_JC VARCHAR(80) not null,
  XYBZ  CHAR(1) not null,
  primary key (XH)
);
 comment on table TMP_ZYGJ is '主要国家';
 comment on column TMP_ZYGJ.XH is '报表序号';
 comment on column TMP_ZYGJ.GJ_DM is '国家代码';
 comment on column TMP_ZYGJ.GJ_MC is '国家名称';
 comment on column TMP_ZYGJ.GJ_JC is '国家简称';
 comment on column TMP_ZYGJ.XYBZ is '选用标志';