Difference between TRUNCATE,DELETE and DROP commands
1)DELETE-Delete command is using to remove a rows from a table. “Where” clause is used to remove some rows. if no “where” condition specified all rows will be removed. After performing a DELETE operation you need to “commit” or “Rollback” the transaction to make the change permanent or undo it. 2)TRUNCATE- “truncate” removes all rows… Read More »