What is the difference between DROP and TRUNCATE statements?

SQL
#1

TRUNCATE purges the table of all rows, and It is not reversible.

Example

Employee_Table

emp_id emp_name salary dept_id manager_id
E1 Rahul 15000 D1 M1
E2 Manoj 15000 D1 M1
E3 James 55000 D2 M2
E4 Michael 25000 D2 M2
E5 Ali 20000 D10 M3
E6 Robin 35000 D10 M3 
TRUNCATE TABLE Employee_Table;

Output

Employee_Table

emp_id emp_name salary dept_id manager_id

Using the DROP command, a procedure and table from the database cannot be moved backward.

Example

Employee_Table

emp_id emp_name salary dept_id manager_id
E1 Rahul 15000 D1 M1
E2 Manoj 15000 D1 M1
E3 James 55000 D2 M2
E4 Michael 25000 D2 M2
E5 Ali 20000 D10 M3
E6 Robin 35000 D10 M3 
DROP TABLE Employee_Table;

Output

Employee_Table is deleted!