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

Does windows server 2016 come with sql server?

931

Detail about the hardware which is supported by SQL server?

1063

What is a non clustered primary key?

925

What are scalar functions in sql?

1144

How to enter binary string literals in ms sql server?

1160

What are the different types of triggers in SQL SERVER?

1137

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1048

How do indexes help, types?

959

How to receive returning result from a query?

1124

What is a db view?

900

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1514

How to verify the port number of the sql server?

1161

Explain what are magic tables in sql server?

994

What is sql server locking?

992

Can a function call a stored procedure in sql server?

960