1.

What is the difference between the above two queries i.e. DELETE and DROP?

Answer»

The DELETE * FROM table-name query deletes all the rows from the table but, there is still an EMPTY table with no rows and no columns in the database. HOWEVER, the DROP TABLE table-name query deletes all the rows and columns and along with that, the table gets DELETED from the database too i.e. the table is completely removed (deleted) from the database. 



Discussion

No Comment Found