Can anyone tell me the difference between Truncate and delete
Command .Kindly let me know the idea.Any help would be highly
appreciated.

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.

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.