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

explain different types of constraints? : Sql server database administration

913

What is the purpose of sql profiler in sql server?

959

Can I save my report as html, excel or word? : sql server management studio

904

What is triggers and stored procedures?

888

Do you know what are the ways available in sql server to execute sql statements?

961

What is the difference between count and distinct count?

841

What is function of master database?

114

Explain active/passive and active/active cluster configurations?

1013

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

940

What is join query?

836

What is scd (slowly changing dimension)? : sql server analysis services, ssas

951

What are the different Topologies in which Replication can be configured?

1117

role of sql sever 2005 in database rather than any other database

1886

How to encrypt data between dialogs?

1030

what are constraints? Explain different types of constraints? : Sql server database administration

918