Monday, August 3, 2015

SQL tutorial - lesson 26 - Truncate

If you want to remove all the records in the table then  you can use Truncate as Truncate will delete all the records in the table but it will not delete the structure

syntax:

truncate table emp;

when you run the above query it will remove all the records from the table.

No comments:

Post a Comment