alter table t_yb add orgCode varchar(10);
ALTER TABLE t_org ADD CONSTRAINT t_org_name_uqUNIQUE("name");
ALTER TABLE t_org ADD CONSTRAINTPK_t_org_code PRIMARYKEY("code");
删除主键及索引altertable t_org drop constraint SYS_C0020274 cascade drop index;
alter table t_yb add orgCode varchar(10);
ALTER TABLE t_org ADD CONSTRAINT t_org_name_uqUNIQUE("name");
ALTER TABLE t_org ADD CONSTRAINTPK_t_org_code PRIMARYKEY("code");
删除主键及索引altertable t_org drop constraint SYS_C0020274 cascade drop index;