oracle、DB2、Informix常用约束语句
来源:互联网 发布:ipv6跟ipv4无网络权限 编辑:程序博客网 时间:2024/06/05 04:16
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 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
阅读全文
0 0
- oracle、DB2、Informix常用约束语句
- informix dbschema 常用语句
- 对比SQL SERVER,ORACLE,DB2上约束建立语句!
- informix的常用SQL语句
- DB2与Sybase/Oracle/Informix的比较
- 关于informix和oracle,DB2的记录
- DB2常用语句总结
- DB2常用语句总结
- DB2常用语句
- DB2常用语句
- DB2常用语句记录
- DB2常用语句总结
- db2常用语句
- db2常用语句更新
- db2 常用语句
- DB2常用语句
- DB2监控常用语句
- oracle约束语句
- 网络层-7、网络地址转换-NAT
- 关于pip3 install error(invalid command 'egg_info')
- jxl 实现excel动态水印
- include指令和include动作区别
- ios友盟分享
- oracle、DB2、Informix常用约束语句
- Docker安装mysql 配置远程登录
- IDEA 快捷键修改(长期更新)
- 实现Form表单提交页面不进行跳转
- WebSocket In ASP.NET Core
- 17090701_CentOS7(64)下MySQL卸载、安装与配置
- C#中的两把双刃剑:抽象类和接口
- ASP.NET Core依赖注入解读&使用Autofac替代实现
- HDU 3861 The King’s Problem 强连通缩点+最小路径覆盖