Deleting Entire Data

The TRUNCATE TABLE statement is used to delete the entire data that is stored in a table. This statement is same as DELETE statement, the only difference being that you have to mention which rows to delete in case of DELETE statement while in the case of TRUNCATE TABLE statement all the rows in the specified table will be deleted.

Remember that only the data will be deleted. The table will still exist with all the data type specifications.

Syntax:

TRUNCATE TABLE table_name;

Hence, to delete the entire data from the table, Emp_Add, the SQL query would be:

TRUNCATE TABLE Emp_Add;