oracle怎么设置外键

oracle数据库设置外键问题

SQL?drop?table?Stu;

drop?table?Stu

*

ERROR?位于第?1?行:

SQL?create?table?Stu(

表已创建.

SQL?drop?table?Cou;

drop?table?Cou

SQL?create?table?Cou(

SQL?drop?table?SC;

drop?table?SC

SQL?create?table?SC(

SQL?

SQL?ALTER?TABLE?SC?ADD?CONSTRAINT?fk_SC_Stu?FOREIGN?KEY?(sno)?REFERENCES?Stu;

表已更改.

SQL?ALTER?TABLE?SC?ADD?CONSTRAINT?fk_SC_Cou?FOREIGN?KEY?(cno)?REFERENCES?Cou;

SQL

oracle怎么创建外键?

oracle中 怎么设主外键?

以oracle自带的用户scott为例.

create?table?dept(

);

create?table?emp(

hiredate?date,

以上就是土嘎嘎小编为大家整理的oracle怎么设置外键相关主题介绍,如果您觉得小编更新的文章只要能对粉丝们有用,就是我们最大的鼓励和动力,不要忘记讲本站分享给您身边的朋友哦！！