InterviewSolution
Saved Bookmarks
| 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. |
|