sql server中截断和删除的区别是什么? [英] what is the diffrence between truncate and delete in sql server?

问题描述

谁能给我列出 SQL Server 中 truncate 和 delete 之间的所有区别?

解决方案

你应该在问之前谷歌它.

截断

1. 截断删除所有引用来自数据库.
2. 快速
3. 事务日志中没有条目.
4. 一旦删除就无法恢复.
5. 页面引用已清除.
6. 全部或无
7. 标识列被重新初始化播种
8. 截断是 DDL

<块引用>

截断表 tblName

不能提供条件

删除

1. 条目在交易日志中进行.
2. 可恢复
3. 慢
4. 基于每条记录的删除
5. 引用在页面中维护
6. 身份从上一个开始位置
7. DML

<块引用>

从表名中删除

这两种方法都不会对表格产生任何结构.在执行任何操作之前必须删除所有引用，尽管当与 Cascade = true for delete 一起使用时它不适用于删除

Can anybody provide me the list of all the differences between truncate and delete in SQL server?

解决方案

You should google it before asking.

Truncate

1. Truncate removes all the references from database.
2. Fast
3. No entry in transaction log.
4. Cannot be recovered if removed once.
5. Page refrences are cleared.
6. All or none
7. Identity column gets re-initialized to seed
8. Truncate is DDL

Truncate Table tblName

No contidion can be given

Delete

1. Entries are made at Transaction log.
2. Recoverable
3. Slow
4. Per record based deletion
5. References are mainained in page
6. Identity starts from its previous position
7. DML

Delete FROM tableName

None of the two effects any structure to table. All references must be removed before performing any of the operation, although it doesn't applies to delete when used with Cascade = true for delete

这篇关于sql server中截断和删除的区别是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！