oracle怎么创建外键?

oracle怎么创建外键?,第1张

create TABLE zhao(\x0d\x0a id number primary key,\x0d\x0a mingcheng nvarchar2(50),\x0d\x0a neirong nvarchar2(50),\x0d\x0a jiezhiriqi date,\x0d\x0a zhuangtai nvarchar2(50)\x0d\x0a)\x0d\x0acreate TABLE tou(\x0d\x0a id number primary key,\x0d\x0a zhao_id number,\x0d\x0a toubiaoqiye nvarchar2(50),\x0d\x0a biaoshuneirong nvarchar2(50),\x0d\x0a toubiaoriqi date,\x0d\x0a baojia number,\x0d\x0a zhuangtai nvarchar2(50),\x0d\x0a foreign KEY(zhao_id) REFERENCES zhao(id)\x0d\x0a)\x0d\x0aforeign key (zhao_id) references to zhao(id)\x0d\x0a多了个to

http://zhidao.baidu.com/link?url=KkU55zptqm0gI-w2oGYn_G9jI1SmYxNJl6vVms8ivisQNlYh6IkdcC4Rg6yDZL5_ajFaAw83KQaQSz3L8pEAWq


欢迎分享,转载请注明来源:内存溢出

原文地址: https://outofmemory.cn/tougao/11004754.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2023-05-12
下一篇 2023-05-12

发表评论

登录后才能评论

评论列表(0条)

保存