أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
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