DB2 修改表列相关属性

1.更改类型

 ALTER TABLE "SCHEMA"."TABLENAME" ALTER COLUMN "COL" SET DATA TYPE VARCHAR(32);  

注：设置为主键的列不能更改类型

2.更改默认值 

ALTER TABLE "SCHEMA"."TABLENAME" ALTER COLUMN "COL" SET DEFAULT 'ABC';  

3.系统默认值

 ALTER TABLE "SCHEMA"."TABLENAME" ALTER COLUMN "COL" SET DEFAULT; --设置默认值  
 ALTER TABLE "SCHEMA"."TABLENAME" ALTER COLUMN "COL" DROP DEFAULT; --删除默认值  

4.更改是否允许空值

 ALTER TABLE "SCHEMA"."TABLENAME" ALTER COLUMN "COL" SET NOT NULL;  
 ALTER TABLE "SCHEMA"."TABLENAME" ALTER COLUMN "COL" DROP NOT NULL;

5.创建、删除唯一约束

ALTER TABLE "SCHEMA"."TABLENAME" ADD unique("COL")
ALTER TABLE "SCHEMA"."TABLENAME" DROP unique "COL"

6.创建主键约束

ALTER TABLE "SCHEMA"."TABLENAME" ADD PRIMARY key ("COL1","COL2")
ALTER TABLE "SCHEMA"."TABLENAME" DROP PRIMARY key

☆注：
1、更改列类型，是否允许空值后，需要执行REORG TABLE "TABLENAME";  
2、更改默认值后，通常需要执行UPDATE "SCHEMA"."TABLENAME" SET "COL" = DEFAULT WHERE "COL" IS NULL;