+ 2

What is the differences between drop and delete in SQL?

23rd Feb 2021, 1:42 AM
T. Siva Kiran
T. Siva Kiran - avatar
7 Réponses
23rd Feb 2021, 7:20 AM
Alphin K Sajan
Alphin K Sajan - avatar
+ 2
T.Siva Kiran Drop means parmanent deleted SQL object And delete means clear selected data from table data or clear all table data
23rd Feb 2021, 12:33 PM
Gaurav Dixit🇮🇳
Gaurav Dixit🇮🇳 - avatar
+ 2
Tsadiku Mengste Drop not remove data it delete objects like table, view , trigger, key etc
10th Apr 2021, 11:36 AM
Gaurav Dixit🇮🇳
Gaurav Dixit🇮🇳 - avatar
0
DELETE command and is used to remove tuples/records from a relation/table. Whereas DROPis used to remove named elements of schema like relations/table, constraints or entire schema.
23rd Feb 2021, 2:16 AM
aslam Sidheeq
0
clearly deleted data from a table
13th Mar 2021, 11:31 AM
Ķīñg Óŕò Gæzägŋ
Ķīñg Óŕò Gæzägŋ - avatar
0
delete is removed only selected cell while drop removed the entire data
10th Apr 2021, 11:13 AM
Tsadiku Mengste
Tsadiku Mengste - avatar