Can anyone tell me the difference between Truncate and delete
Command .Kindly let me know the idea.Any help would be highly
appreciated.
firoz.raj
-3
Posting Pro in Training
Recommended Answers
Jump to PostDelete
-----------
1. DML
2. Affects only data.
3. Data can be rolled back after this command.Truncate
----------------
1. DDL
2. Affects both data and structure (resets the High Water Mark)
3. Data can't be rolled back after this command.
All 2 Replies
MahiPV
0
Newbie Poster
DELETE is a regular DML statement, using which selective records can be deleted with the WHERE clause and if it is a part of a transacation then the DELETE can be rolled back. Where as TRUNCATE is a DDL and it cannot be rolled back(issues an internal commit) and cannot use the WHERE clause.
debasisdas
580
Posting Genius
Featured Poster
Delete
-----------
1. DML
2. Affects only data.
3. Data can be rolled back after this command.
Truncate
----------------
1. DDL
2. Affects both data and structure (resets the High Water Mark)
3. Data can't be rolled back after this command.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.