Sql truncate

This article is tagged with: Sql truncate and mysql

query to empty table data in sql server

TRUNCATE TABLE table_name;

truncate table

TRUNCATE TABLE Categories;

SQL TRUNCATE

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;

truncate table

TRUNCATE TABLE table;

what is truncate

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 mysql

TRUNCATE TABLE `fourniture`

This article is tagged with: Sql truncate and mysql