what is truncate in sql
snippet in sql

query to empty table data in sql server

user5007

TRUNCATE TABLE  table_name;

truncate table

user2756


  TRUNCATE TABLE Categories;
 

truncate table

user5666

TRUNCATE TABLE table;

what is truncate in sql

user9599

DELETE -
-DML COMMAND
-Delete Rows from the table one by one
-We can use where clause with Delete to delete single row
-Delete is slower than truncate
-ROLLBACK is possible with DELETE

DROP-
-DDL COMMAND
-Delete the entire structure or schema
-We can't use where clause with drop
-Drop is slower than DELETE & TRUNCATE
-ROLLBACK IS NOT POSSIBLE WITH DROP

TRUNCATE-
-DDL COMMAND
-Truncate deletes rows at a one goal
-We can't use where clause with Truncate
-Truncate faster than both DELETE & DROP
-Rollback is not possible with Truncate

SQL TRUNCATE

user609

Mit TRUNCATE TABLE entfernt alle Zeilen aus einer Tabelle, aber die 
Tabellenstruktur und ihre Spalten bleiben erhalten. Mit DROP TABLE 
wird die Tabellendefinition zusätzlich zu den Daten entfernt.

  TRUNCATE TABLE suppliers;