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

When would you use a before or after trigger?

905

Can we use where clause in union?

1063

How can I get data from a database on another server?

989

What are the options which must be set to allow the usage of optimistic models?

961

What is server-level principal?

122

what are user defined datatypes? : Sql server database administration

964

How do I completely remove sql server instance?

1099

What is a non clustered primary key?

920

What is checkpoint process in the sql server?

1029

What is difference between clustered and non clustered index?

982

Does a server store data?

920

How do I edit a stored procedure in sql server?

922

what are the new features introduced in sql server 2000? : Sql server database administration

914

What are the three different part of rdl file explain them?

267

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

992