ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Atif Aqeel , Founder And Director , Xesense
تاريخ النشر: 2013/10/11
Eslam Mohamed
من قبل Eslam Mohamed , Technical Consultant , Meridium

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.

 

Saba Wasim
من قبل Saba Wasim , IT Project Manager, Solution Manager , COTSYS

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

The DROP command removes a table from the database.

Muhammad Zeshan
من قبل Muhammad Zeshan , Web Application Developer , Inquiron

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.

Manaf Bilavinakath
من قبل Manaf Bilavinakath , Acting Supervisor , ADNOC

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

Jaffar Shariff
من قبل Jaffar Shariff , Senior process executive , infosys

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.

vishal pathak
من قبل vishal pathak

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....

Bhavani Namburi
من قبل Bhavani Namburi , Intern , Rennaissence Softlabs

DELETE is used to remove the content of table

DROP is used to remove the table from database

Sajad Hussain
من قبل Sajad Hussain , Sr Software Engineer ERP , Precision Industry

Delete  command used for particular relation rows.

 

Drop to a particular table

 

المزيد من الأسئلة المماثلة