SQL TRUNCATE TABLE

The SQL TRUNCATE TABLE clause deletes all rows from a database table. Here is the SQL TRUNCATE TABLE syntax:

 TRUNCATE TABLE Weather 

The SQL TRUNCATE TABLE clause does the same as a SQL DELETE clause which doesn't have a SQL WHERE clause. The following two SQL statements are equivalent:

 TRUNCATE TABLE Weather 


 DELETE FROM Weather 

Use SQL TRUNCATE TABLE only when you want to delete all rows in a table.
Best 60 – 65 inch Smart LED TV to Buy in India
Best 55 inch LED TV to Buy in India