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

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.

1. DML
2. Affects only data.
3. Data can be rolled back after this command.

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.