SQL TRUNCATE
snippet in sql

truncate table mysql

user7260

TRUNCATE TABLE `fourniture`

query to empty table data in sql server

user3487

TRUNCATE TABLE  table_name;

truncate table

user5422


  TRUNCATE TABLE Categories;
 

what is truncate

user7586

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

truncate table

user7753

TRUNCATE TABLE table;

SQL TRUNCATE

user3856

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;