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

How do users use Report Builder with SQL Server data sources?

164

Explain what are the authentication modes in sql server?

1071

How do I debug a stored procedure in sql server?

1175

How do I start sql server 2017?

985

What is sub query and its properties?

1024

How can you set the threshold at which sql server will generate keysets asynchronously?

1052

What is a not null constraint?

1088

What are sql servers used for?

1111

What is tabulation?

1012

How to create an multi-statement table-valued function?

1048

Explain the microsoft sql server delete command?

1079

What do you mean by a Composite primary key?

1187

How to list all columns in a table using odbc_columns()?

1032

Explain about sql server login?

1134

Do you know what is sql service broker?

1161