Java DB SQL

 ÏÔʾËùÓеÄÓû§±í
        select tablename from sys.systables where tabletype='T'
´´½¨±í
Create Table MAPS(
ID integer not null generated always as identity(start  with 1,increment by 1),
map_name varchar(40),
area_int int,
area decimal(8,4) not null,
picture blob(102400),
unique(map_id,map_name)
)
ÏÂÃæÊÇÒ»¸ö´Óɾ³ý±í,´´½¨±í,´ÓÎı¾Îļþµ¼ÈëÊý¾Ý,¸üÐÂÊý¾ÝµÄÀý×Ó.
 
drop table client;
CREATE TABLE client (
  id integer not null generated always as identity(start  with 1,increment by 1),
  barcode varchar(20) default NULL,
  pinyin varchar(10) default NULL,
  type varchar(50) default NULL,
  name varchar(30) default NULL,
  sex varchar(10) default NULL,
  title varchar(200) default NULL,
  department varchar(200) default NULL,
  company varchar(255) default NULL,
  industry varchar(50) default NULL,
  address varchar(255) default NULL,
  postcode varchar(8) default NULL,
  areacode varchar(10) default NULL,
  tel varchar(20) default NULL,
  fax varchar(20) default NULL,
  mobile varchar(15) default NULL,
  email varchar(200) default NULL,
  state smallint NOT NULL default 1,
  regtime timestamp,
  oldbarcode varchar(20) default NULL,
  islogin smallint default 0
);
call SYSCS_UTIL.SYSCS_IMPORT_DATA(null,'CLIENT','BARCODE,PINYIN,TYPE,NAME,SEX,TITLE,
DEPARTMENT,COMPANY,INDUSTRY,ADDRESS,POSTCODE,AREACODE,TEL,
FAX,MOBILE,EMAIL',null,'c:/data.txt',null,null,'GBK',0);
update client set state=1,islogin=0,oldbarcode=barcode;