difference between delete, truncate and drop?
Anónimo
delete used to delete specific data, we can use with the where clause, delete can rollback the changes, delete the tabe row before deleting the row truncate used to delete entire data of the table, trucante can not used with where clause, truncate can't be rollback the changes, it is locks entire table Drop command is used to remove table definition & it's contents, drop command table space is free from memory,drop command viewof the table doesnot exits