导读：复制代码 代码如下:TRUNCATE TABLE (Transact-SQL)Removes all rows from a table without logging the individual ro..
复制代码 代码如下:
TRUNCATE TABLE (Transact-SQL)
Removes all rows from a table without logging the individual row deletions.
TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause;
however, TRUNCATE TABLE is faster and uses fewer system and transaction log resources.
两者的区别在于Truncate快，而且释放日志所占资源，不记录由于删除行的影响所产生的日志。
更多文章请关注《万象专栏》
转载请注明出处：https://www.wanxiangsucai.com/read/cv148030
话题推荐： #t-sql#
#清空表数据#
#truncate#