人大金仓SQL记录

#人大金仓SQL记录
//修改表描述
COMMENT ON TABLE bpm_form IS ‘工作流的表单定义1’;
//修改字段描述
comment on column dinding_send_object.apply_id is ‘发放计划id’;
//修改类型与长度
ALTER TABLE dinding_recipes ALTER COLUMN dinding_name TYPE VARCHAR(100)
//可以为空
ALTER TABLE system_menu ALTER COLUMN permission drop not NULL;
//自增主键
ALTER TABLE dinding_product ALTER COLUMN id SET DEFAULT nextval(‘dinding_product_id_seq’);
//字段换名
ALTER TABLE “DZ_ALERT_DETAIL” RENAME “regiontype” TO “region_type”;

//修改表描述
COMMENT ON TABLE bpm_form IS '工作流的表单定义1';
//修改字段描述
comment on column dinding_send_object.apply_id  is '发放计划id';
//修改类型与长度
ALTER TABLE dinding_recipes ALTER COLUMN dinding_name TYPE  VARCHAR(100)
//可以为空
ALTER TABLE  system_menu ALTER COLUMN permission drop not  NULL;
//自增主键
ALTER TABLE dinding_product ALTER COLUMN id  SET DEFAULT nextval('dinding_product_id_seq');
//字段换名
ALTER TABLE "DZ_ALERT_DETAIL" RENAME "regiontype" TO "region_type";