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,100 points
72 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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,680 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,260 points
117 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,040 points
36 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,100 points
21 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,100 points
20 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,100 points
18 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 darklord
• 6,140 points
51 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 darklord
• 6,140 points
35 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,260 points
30 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
54 views
0 votes
1 answer

How to delete / drop multiple tables in AWS athena?

It is not possible to run multiple ...READ MORE

answered Jan 17 in AWS by Edureka
• 4,180 points
199 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.