DB2 语句集合

1.创建表：alter table [表名] ([字段名] [column_type])

CREATE  TABLE  DEMO(ID  VARCHAR(255));

2.给表中插入字段:alter table [表名] add [字段名] [column_type]

ALTER  TABLE DEMO ADD COLUMN AGE INTEGER;

3.修改字段类型:alter table  [表名] alter column [字段名] set data type  [column_type] 

ALTER TABLE DEMO ALTER COLUMN AGE  SET DATA TYPE VARCHAR(5);

4.删除字段：alter table [表名] drop column [字段名]

ALTER TABLE DEMO  DROP COLUMN AGE;

5.字段设置默认值：alter table [表名] alter column [字段名] set default [value] 

ALTER TABLE DEMO ALTER COLUMN AGE SET DEFAULT 0;

6.添加带默认值的字段 

 alter table [表名] add column [字段名] [column_type] not null with default [value] 

ALTER TABLE DEMO ADD COLUMN AGE INTEGER NOT NULL WITH  DEFAULT 0;

7.设置字段默认时间为当前时间：alter table [表名] alter column [字段名] set default  current date; 

ALTER TABLE DEMO ALTER COLUMN TIMKEY SET DEFAULT CURRENT DATE;

8.表注释的添加：comment on table [表名]  is  '注释内容';

COMMENT ON TABLE IS '测试';

9.列注释的添加：comment  on  column  [表名].[字段名]   is  '注释内容';

COMMENT ON COLUMN SEX IS ' 01-男,02-女';

10.表中加主键

ALTER TABLE "模式"."表名" ADD PRIMARY KEY ("字段")

11.清除表

TRUNCATE TABLE 表名 IMMEDIATE;

12.报错代码：for reason code “7

call Sysproc.admin_cmd('REORG table 表名');