Truncate is DDL Command while Delete is DML Command

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

Question Posted / sachin patil

Answer Posted / sachin patil

Is This Answer Correct ?

26 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to drop an existing stored procedure in ms sql server?

1088

Explain linked server in sql?

1294

What do you understand by sql server agent?

1026

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1066

What is a trigger in sql server?

1229

What is microsoft sql server?

1014

How to deploy the Report?

140

Explain triggers in sql?

1003

How to connect ms access to sql servers through odbc?

1069

What are the database objects? : SQL Server Architecture

1098

Describe in brief databases and sql server databases architecture.

1066

What are the 7 disadvantages to a manual system?

1032

Explain filestream storage of sql server 2008?

1080

Explain full-text query in sql server?

1054

How many ways to create table-valued functions?

1056