oracle、DB2、Informix常用约束语句
发布时间：2020-12-12 14:24:53 所属栏目：百科 来源：网络整理
导读：alter table student disable constraint fk_student; --oracle ALTER TABLE student ALTER FOREIGN KEY fk_student NOT ENFORCED; --DB2 ALTER TABLE student ADD CONSTRAINT FOREIGN KEY (college_id) REFERENCES college CONSTRAINT student_fk1; --增加外
|
alter table student disable constraint fk_student; --oracle
ALTER TABLE student ALTER FOREIGN KEY fk_student NOT ENFORCED; --DB2 ALTER TABLE student ADD CONSTRAINT FOREIGN KEY (college_id) REFERENCES college CONSTRAINT student_fk1; --增加外键 ALTER TABLE student DROP CONSTRAINT fk_student;--删除外键 alter table student add constraint fk_student foreign key(college_id) references college(college_id);
alter table student2 add constraint fk_student foreign key(college_id) references college(college_id);--oracle alter table student2 add constraint fk_student foreign key(college_id) references college(college_id);--db2 ALTER TABLE student ADD CONSTRAINT FOREIGN KEY (college_id) REFERENCES college CONSTRAINT student_fk1; --informix （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |