There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible.
I need to run each test against a clean version of the database so I need to remove all the regular data left from previous ...
The SQL TRUNCATE TABLE command is used to delete complete data from an existing table. You can also use DROP TABLE command to delete complete table but it would remove complete table structure form ...