oracle删除,修改主健/外键代码
删除索引:
drop index PK_fsoReplan
删除主键:
ALTER TABLE fsoreplan drop CONSTRAINT PK_fsoReplan
删除外键:
ALTER TABLE tablea_tableb drop CONSTRAINT FK_AB
创建主键:(多个主健一起创建)
drop index PK_fsoReplan
删除主键:
ALTER TABLE fsoreplan drop CONSTRAINT PK_fsoReplan
删除外键:
ALTER TABLE tablea_tableb drop CONSTRAINT FK_AB
创建主键:(多个主健一起创建)
ALTER TABLE fsoreplan add CONSTRAINT PK_fsoReplan PRIMARY KEY (RepolicyNo,ReendorNo, RepayNo, SerialNo, ReinsMode,BelongType,PayType);
注:fsoreplan 是表名,PK_fsoReplan 是主键名,FK_AB是外键名;