Let‘s understand the difference between Delete and Drop command. Delete command is often used to delete selected rows using WHERE clause and in case you don’t use WHERE clause, all rows will get deleted from the table where as drop command is often used to delete a table from the database.
Example of Delete command:-
DELETE FROM student WHERE sname = “XYZ” so all rows are deleted whose sname is XYZ
Example of Drop command:-
DROP TABLE student
Hence student table has been deleted
Sorry, but you are not allowed to view signatures , please Register or Login