TRUNCATETABLE

  • 网络表格名

网络释义

1.
表格名
MYSQL基本知识... ... DROPTABLE 表格名 ——删除表格 TRUNCATETABLE 表格名 ——清楚表格数据 /***********VIEW 视图*…
www.cnblogs.com|基于 1 个网页

例句

释义:
全部全部,表格名表格名
类别:全部全部,口语口语,书面语书面语,标题标题,技术技术
来源:全部全部,字典字典,网络网络
难度:全部全部,简单简单,中等中等,难难
1.
Individual deletions of rows are not entered into the transaction log , so the TRUNCATE TABLE operation is not replicated .
各行删除操作不记入事务日志，因此不复制TRUNCATETABLE操作。
2.
The TRUNCATE TABLE statement is entered into the transaction log as a single statement , like data definition statements .
与数据定义语句一样，TRUNCATETABLE语句作为单个语句记入事务日志。
3.
You can use the TRUNCATE TABLE statement as a fast method of deleting all the rows in a table.
您可以使用TRUNCATETABLE语句作为快速删除表中所有行的方法。
www.ianywhere.com
4.
The TRUNCATE TABLE statement is not executed within a trigger.
TRUNCATETABLE语句不在触发器内执行。
www.ianywhere.com
5.
The TRUNCATE TABLE statement is not executed within an atomic statement.
TRUNCATETABLE语句不在原子语句内执行。
www.ianywhere.com
6.
To execute TRUNCATE TABLE, the user must have ALTER permissions on the specified table.
若要执行TRUNCATETABLE，用户必须对指定表具有ALTER权限。
msdn2.microsoft.com
7.
TRUNCATE TABLE is a non-logged operation that does not fire triggers.
TRUNCATETABLE是不会激发触发器的日志未记录的操作。
msdn2.microsoft.com
8.
A TRUNCATE TABLE statement is not caught by a DELETE trigger.
DELETE触发器不能捕获TRUNCATETABLE语句。
msdn2.microsoft.com
9.
TRUNCATE TABLE is faster than DELETE and uses fewer system and transaction log resources.
TRUNCATETABLE比DELETE速度快，且使用的系统和事务日志资源少。
msdn2.microsoft.com
10.
After a TRUNCATE TABLE statement, the table structure and all of the indexes continue to exist until you issue a DROP TABLE statement.
执行TRUNCATETABLE语句后，表结构及所有索引仍然存在，直到发出DROPTABLE语句。
www.ianywhere.com