orcal创建外键的几种方式

最新推荐文章于 2024-01-18 14:59:48 发布

songzz820816

最新推荐文章于 2024-01-18 14:59:48 发布

阅读量964

点赞数

分类专栏： orcal 文章标签： orcal创建外键

本文链接：https://blog.csdn.net/songzz820816/article/details/17879219

版权

orcal 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

--表创建完成后添加外键

create table distict
(
id number(4) primary key,
name nvarchar2(20) not null
);

create table street
(
id number(4) primary key,
name nvarchar2(50) not null,
district_id number(4)
);

alter table street add constraint distict_fk foreign key (district_id ) references distict (id);

--创建表的同时添加外键

create table distict
(
id number(4) primary key,
name nvarchar2(20) not null
);

create table street
(
id number(4) primary key,
name nvarchar2(50) not null,
district_id number(4),

constraint distict_fk foreign key (district_id ) references distict (id)
);

--在字段属性中添加外键

create table distict
(
id number(4) primary key,
name nvarchar2(20) not null
);

create table street
(
id number(4) primary key,
name nvarchar2(50) not null,
district_id references distict(id)
);