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,130 points
187 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,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,240 points
188 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,050 points
50 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,130 points
33 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,130 points
30 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,130 points
25 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
64 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
45 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
62 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
66 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
528 views