Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the truncate table operation fails.
此外,被truncate的表和其他表之间是不能有外键约束的,否则truncate TABLE操作会失败。
TRUNCATE table statement This statement quickly deletes the contents of an entire table without firing triggers.
TRUNCATE 表语句此语句无需激活触发器即可快速删除整个表的内容。
Select the Truncate table action to delete all the existing rows in the Orders table before the data load operation starts.
在数据加载操作开始之前,选择truncate表操作删除orders表中的所有已有行。
Membership of a group that has sufficient authority to issue TRUNCATE TABLE statements and have CREATE TABLE statement privileges.
一组成员,拥有足够的授权来发出TRUNCATE table语句且拥有CREATE table语句权限。
Membership of a group that has sufficient authority to issue TRUNCATE TABLE statements and have CREATE TABLE statement privileges.
一组成员,拥有足够的授权来发出TRUNCATE table语句且拥有CREATE table语句权限。
应用推荐