Delete: is a DML command. Truncate: is a DDL command. Delete & Tru

Can you tell me the difference between DELETE & TRUNCATE
commands?

Question Posted / kapil

Answer Posted / kapil

Delete: is a DML command.
Truncate: is a DDL command.

Delete & Truncate both can be rolled back.
Untill you have not commit transaction.

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What you can do to delete a table without the delete trigger firing?

971

What can be used instead of trigger?

1156

What is the exact numeric data type in sql?

998

Is resultset an interface?

959

Which are the third-party tools used in sql server and why would you use them?

902

Explain important index characteristics?

1031

Explain identity in sql server?

1003

What is difference between join and natural join?

961

Differentiate between SQL and ORACLE joins and write their syntax.

1032

What is set nocount on?

936

How to delete an existing database user?

1014

what are defaults? : Sql server database administration

1087

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1083

Explain primary key and foreign key constraints?

1029

Write a program using SQL queries to find a unique entry in a table.

990