建站
咨詢
售后
建站咨詢
新聞中心
oracle創(chuàng)建主外鍵，求解
1
創(chuàng)新互聯(lián)公司是一家專注于成都網(wǎng)站設(shè)計(jì)、做網(wǎng)站、成都外貿(mào)網(wǎng)站建設(shè)公司與策劃設(shè)計(jì),奉賢網(wǎng)站建設(shè)哪家好?創(chuàng)新互聯(lián)公司做網(wǎng)站,專注于網(wǎng)站建設(shè)十年,網(wǎng)設(shè)計(jì)領(lǐng)域的專業(yè)建站公司;建站業(yè)務(wù)涵蓋:奉賢等地區(qū)。奉賢做網(wǎng)站價(jià)格咨詢:028-86922220
一個(gè)表只能有一個(gè)主鍵，但是可以用兩個(gè)字段做聯(lián)合主鍵，但針對(duì)你發(fā)上來(lái)的情況，板塊表只可以用id字段做主鍵
create?table?bk(
id?number?primary?key,
name?varchar2(50)?not?null);
然后創(chuàng)建帖子表
create?table?tz(
id?number??primary?key,
title?varchar2(50),
bkid?number,
foreign?KEY(bkid)?REFERENCES?bk(id));
注意 ：一定要先創(chuàng)建bk表，再創(chuàng)建tz表
oracle創(chuàng)建外鍵
create TABLE zhao(
id number primary key,
mingcheng nvarchar2(50),
neirong nvarchar2(50),
jiezhiriqi date,
zhuangtai nvarchar2(50)
);
create TABLE tou(
id number primary key,
zhao_id number,
toubiaoqiye nvarchar2(50),
biaoshuneirong nvarchar2(50),
toubiaoriqi date,
baojia number,
zhuangtai nvarchar2(50),
foreign KEY(zhao_id) REFERENCES zhao(id)
);
foreign key (zhao_id) references to zhao(id)
多了個(gè)to
oracle怎么創(chuàng)建外鍵？
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多了個(gè)to
oracle 如何創(chuàng)建表外鍵
--使用表級(jí)約束
CREATE TABLE table_name
(column_1 datatype ,
column_2 datatype ,
...
CONSTRAINT fk_column
FOREIGN KEY (column_1, column_i, ... column_n)
REFERENCES parent_table (column_1, column_i, ... column_n)
);
--使用列級(jí)約束
CREATE TABLE table_name
(column_1 datatype ,
column_2 datatype CONSTRAINT fk_column REFERENCES parent_table (column_name),
...
);
在oracle數(shù)據(jù)庫(kù)中怎樣創(chuàng)建主外鍵關(guān)系
主外鍵需要依托多表來(lái)創(chuàng)建，方法如下：
創(chuàng)建主表：
CREATE?TABLE?SCOTT.DEPT?
(DEPTNO?NUMBER(2,0)?PARIMARY?KEY,?
DNAME?VARCHAR2(14),?
LOC?VARCHAR2(13));
創(chuàng)建副表及外鍵：
CREATE?TABLE?EMP?
(EMPNO?NUMBER(4,0)?PRIMARY?KEY,?
ENAME?VARCHAR2(10),?
JOB?VARCHAR2(9),?
MGR?NUMBER(4,0),?
HIREDATE?DATE,?
SAL?NUMBER(7,2),?
COMM?NUMBER(7,2),?
DEPTNO?NUMBER(2,0),
CONSTRAINT?FK_DEPTNO?FOREIGN?KEY?(DEPTNO)?REFERENCES?DEPT?(DEPTNO));
分享題目：oracle外鍵怎么創(chuàng)建,Oracle創(chuàng)建外鍵
本文來(lái)源：http://www.dlmjj.cn/article/hshces.html
