What is the difference between drop and delete table in database?

Delete Command

--------------------------

- DML (Data Manipulation Language)

- Used To Delete Rows From Table

- Support Where Clause To Filter Rows To Be Deleted

- Row by Row Structure When Delete

- Support Rollback Command after Delete

Drop Command

------------------------

- DDL (Data DefinitionLanguage)

- Used To Delete Table (Structure + Data) from Database

- Doesn't Support Where Clause To Filter Rows To Be Deleted

- Doesn't Support Rollback.

The DELETE command is used to remove rows from a table.

The DROP command removes a table from the database.

DROP command deleting the table and its structure from the data base.

DELETE command used for deleting the records from the table,and it removing the table space which is allocated by the data base, and returns number of rows deleted.

drop table is used to remove the table from the database. its a DDL command. it affects the schema of the table. Delete is used to remove the details from a table.if we give any condition, for eg:delete from table_name where serial_number(column_name) =20 , only the row having serial number20 wil  be deleted.and if we do not give any condition, for eg:

delete from table_name , the entire rows of the table will be deleted.

please send your comments to my answer, . thanks in advance

drop command is used to remove the entire structure of a table in database,where as coming to the delete command it just removes the content in the table

Drop command is used to remove table from database and delete is used to delete a specific row from the database

Deleting table effects to remove or delete the complete data or rows from the table. Droping table effects to delte the table from database

Delete clause will just delete the entries in the table, without affecting the structure of the table, but

Drop clause will erase the complete table from the database.

Delete removes the rows where data of the tables inserted ,but not the columns values..

Drop removes data of the tables along with the column values....

DELETE is used to remove the content of table

DROP is used to remove the table from database

Delete  command used for particular relation rows.

Drop to a particular table