SQL TRUNCATE TABLE

SQL DELETE statement can delete off all the rows inside a particular table. Other than that TRUNCATE also can use to delete all the records in a table.

TRUNCATE statement is use for Empty a table. And also reset all the storage parameters starting from Default. Example: some auto increasing number that set for some column will start from 1 if TRUNCATE TABLE statement used.

The main limitation of TRUNCATE is that you cannot use it on a table referenced by an enabled FOREIGN KEY constraint. And the TRUNCATE statement cannot be rollback. It’s very dangerous to use for an application

SQL syntax:

TRUNCATE TABLE [TABLE NAME]

EXAMPLE :

We want to TRUNCATE the table GameScores.

SQL Statement:

TRUNCATE TABLE GameScores