Delete and Drop statements in SQL Server

Question

Aryan Kumar · Answer

Sure, I can help you with that.
The DELETE and DROP statements are two of the most important statements in SQL Server. They are used to delete data from tables and to drop tables from the database.
The DELETE statement is used to delete rows from a table. The syntax for the
DELETE statement is as follows:
SQL
DELETE FROM table_name
WHERE condition;
The table_name is the name of the table from which you want to delete rows. The
condition is an optional clause that specifies the rows that you want to delete. If you do not specify a
condition, then all rows from the table will be deleted.
The DROP statement is used to drop tables from the database. The syntax for the
DROP statement is as follows:
SQL
DROP TABLE table_name;
The table_name is the name of the table that you want to drop.
Difference between DELETE and DROP statements
The main difference between the DELETE and DROP statements is that the
DELETE statement only deletes rows from a table, while the 
DROP statement deletes the entire table.
Here is a table that summarizes the differences between the DELETE and
DROP statements:
Feature
DELETE
DROP
Deletes rows
Yes
No
Deletes the entire table
No
Yes
Used to delete specific rows
Yes
No
Used to delete all rows from a table
No
Yes
When to use the DELETE and DROP statements
The DELETE statement should be used when you want to delete specific rows from a table. The
DROP statement should be used when you want to delete an entire table.
For example, if you want to delete all rows from the Customers table, you would use the following code:
SQL
DELETE FROM Customers;
If you want to delete the Customers table altogether, you would use the following code:
SQL
DROP TABLE Customers;

forum

Delete and Drop statements in SQL Server

Revati S Misra

Can you answer this question?

1 Answers

Liked By

Feature	DELETE	DROP
Deletes rows	Yes	No
Deletes the entire table	No	Yes
Used to delete specific rows	Yes	No
Used to delete all rows from a table	No	Yes