DELETE vs TRUNCATE vs DROP command

+1 vote
Hi!!

Can someone tell me the difference between these three commands?
Aug 23, 2018 in Database by DataKing99
• 8,150 points
670 views

1 answer to this question.

0 votes
After the execution of ‘DELETE’ operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data.

After the execution of ‘TRUNCATE’ operation, COMMIT, and ROLLBACK statements cannot be performed to retrieve the lost data.

‘DROP’ command is used to drop the table or key like the primary key/foreign key.
answered Aug 23, 2018 by CodingByHeart77
• 3,710 points

Related Questions In Database

0 votes
1 answer

Delete row in HBase

In Hbase, whatever you write will be ...READ MORE

answered Jul 23, 2018 in Database by kurt_cobain
• 9,310 points
385 views
0 votes
2 answers

SQL vs NoSQL

Well, it depends on what you are ...READ MORE

answered Aug 10, 2018 in Database by slayer
• 29,280 points
131 views
0 votes
1 answer

Clustered vs Non-clustered Indexes

Clustered indexes - The indexes according to ...READ MORE

answered Aug 20, 2018 in Database by DataKing99
• 8,150 points
83 views
0 votes
1 answer

IN vs OR in the SQL WHERE Clause

I assume you want to know the ...READ MORE

answered Sep 24, 2018 in Database by DataKing99
• 8,150 points
83 views
0 votes
1 answer

What is an ALIAS command?

The ALIAS name can be given to ...READ MORE

answered Oct 22, 2018 in Database by DataKing99
• 8,150 points
87 views
0 votes
1 answer

What is the ALTER command in MySQL?

ALTER The ALTER command is used to add, ...READ MORE

answered Nov 28, 2018 in Database by Sahiti
• 6,290 points
108 views
0 votes
1 answer

What is the UPDATE command in MySQL?

This statement is used to modify the ...READ MORE

answered Nov 28, 2018 in Database by Sahiti
• 6,290 points
90 views
0 votes
1 answer

Which is better database vs. flat files?

Difference between database and flat files are ...READ MORE

answered Oct 11, 2019 in Database by Omaiz
• 560 points
467 views
0 votes
1 answer

sync --delete command removed all local files in AWS S3

aws sync is not used for deleting ...READ MORE

answered Jul 18, 2018 in Cloud Computing by Gopalan
• 1,280 points
632 views
0 votes
1 answer

How to delete cookies using selenium command?

Yes, it is possible to delete the ...READ MORE

answered Dec 31, 2018 in Selenium by Nabarupa
124 views