T-SQL级联删除——ON DELETE CASCADE
来源:互联网 发布:hsk网络考试 编辑:程序博客网 时间:2024/04/28 23:16
ON DELETE CASCADE
创建两张表:
create table class(Id int identity(1,1) primary key,cname nvarchar(20))GOcreate table student(Id int identity(1,1) primary key,sname nvarchar(20),cid int references class(id) on delete cascade--级联删除)GO
插入测试数据:
insert into classselect 'C1' unionselect 'C2' unionselect 'C3'insert into studentselect 'N1',1 unionselect 'N2',1 unionselect 'N3',2
删除class中的数据前:
--Class
Id cname
----------- --------------------
1 C1
2 C2
3 C3
--Student
Id sname cid
----------- -------------------- -----------
1 N1 1
2 N2 1
3 N3 2
删除数据:
delete from class where id = 1;
删除后:
--Class
Id cname
----------- --------------------
2 C2
3 C3
--Student
Id sname cid
----------- -------------------- -----------
3 N3 2
删除Class表中的数据时,Student表中引用对应的Class的数据也删除了。
- T-SQL级联删除——ON DELETE CASCADE
- SQL Server 级联删除 ON DELETE CASCADE
- ON DELETE CASCADE(级联删除)
- SQL SERVER 主键和外键中的 级联删除(ON DELETE CASCADE)和级联更新(ON UPDATE CASCADE)
- SQL SERVER 主键和外键中的 级联删除(ON DELETE CASCADE)和级联更新(ON UPDATE CASCADE)
- delete cascade 级联删除
- 数据库级联更新 on update cascade和级联删除 on delete cascade
- sql 联级删除 ON DELETE CASCADE
- 关系表的级联删除(ON DELETE CASCADE的用法)
- 数据库_级联更新/级联删除_ON UPDATE CASCADE/ON DELETE CASCADE
- on delete cascade和on delete set null的级联删除
- 如何实现关系表的级联删除(ON DELETE CASCADE的用法)
- 如何实现关系表的级联删除(ON DELETE CASCADE的用法)
- 如何实现关系表的级联删除(ON DELETE CASCADE的用法)
- 如何实现关系表的级联删除(ON DELETE CASCADE的用法)
- 如何实现关系表的级联删除(ON DELETE CASCADE的用法)
- CASCADE——SQL, sql server 2000 ,表间数据 ,级联更新删除
- mysql级联删除CASCADE
- 设置路由器多人拨号使用wifi(使用路由器交换机功能)
- mybatis -spring 集成映射原理 --分析
- Linux Kernel Development 笔记(五)内核数据结构
- HTML5未来发展的六大趋势
- 开源 免费 java CMS - FreeCMS1.2-标签 link
- T-SQL级联删除——ON DELETE CASCADE
- ArcEngine 异常来自 HRESULT:0x80040356
- Linq 并发
- ubuntu下ndk编译ffmpeg0.8.1
- oracle分组函数rollup,cube
- chkconfig做了什么
- struts2怎么获得ip地址呢?
- Maven 环境快速搭建二(eclipse+maven2+jetty)
- 静态链表C语言实现详解