SQL TRUNCATE TABLE Statement

SQL TRUNCATE TABLE Statement

This statement is used to delete all rows from the table. Its similar like DELETE statement BUT it does not have WHERE clause in it.

Syntax:

DELETE ALL DATA in table without deleting table structure, index, constraints.

TRUNCATE TABLE "tableName";

Parameters :

tableName : Name of the table which we wish to truncate.

Examples :

We will be using the same table which we have created in the CREATE TABLE and INSERT STATEMENT. 

Using Select to see all the records before truncate query runs.

SELECT * FROM employee;

TRUNCATE TABLE employee;

Above query will delete all the rows in the specified table. Its faster than DELETE query.

Using Select to see all the records after delete query. We are using COUNT(*) function to know about numbers of rows in our table.  And its 0 (zero), Which confirms deletion of all rows in the table.

Newer Post Older Post