truncate and delete 的另一个区别

最新推荐文章于 2022-10-09 14:42:03 发布

iteye_4537

最新推荐文章于 2022-10-09 14:42:03 发布

阅读量120

点赞数

本文记录了在尝试直接删除部门表(dept)数据时遇到的外键约束错误，并展示了如何通过先删除员工表(emp)中的相关记录来解决此问题。此外，还介绍了在存在外键约束的情况下，使用TRUNCATE语句时遇到的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL> delete from dept;
delete from dept
*
ERROR at line 1:
ORA-02292: integrity constraint (SCOTT.FK_DEPTNO) violated - child record found

SQL> truncate table dept;
truncate table dept
*
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

SQL> delete from emp;

14 rows deleted.

SQL> delete from dept;

4 rows deleted.

SQL> rollback;

Rollback complete.

SQL> truncate table emp;

Table truncated.

SQL> truncate table dept;
truncate table dept
*
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys