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.
syntax:
truncate table emp;
when you run the above query it will remove all the records from the table.
No comments:
Post a Comment