TRUNCATE TABLE hr.emp;

? Truncate a table deletes all rows in a table and releases used space.

? Corresponding indexes are trunate.

The effects of using this command are as follows:

1、ALL rows in the table are deleted.

2、NO undo data is generated and the command commits implicitly because TRUNCATE TABLE?is a DDL?

???? ?command.

3、Correspondig indexes are also truncate.

4、A table that is being referenced by a foreign key cannot be truncated.

5、The delete triggers do not fire when this command is used.

轉(zhuǎn)載于:https://blog.51cto.com/sky2012/1079884

總結(jié)

以上是生活随笔為你收集整理的Truncate a table的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。