Question

Differentiate between drop and delete query in SQL with a suitable example.

Answer 1

• The DELETE query removes all the records or specific records from a table, preserving the table structure.
  Example: DELETE FROM Employees WHERE EmployeeID = 5;
• The DROP query removes the entire table or database along with its data.
  Example: DROP TABLE Employees;