both are ddl commands.Drop deletes the table with schema and records but

What is the difference between Drop and Truncate

Question Posted / antim

Answer Posted / antim

both are ddl commands.Drop deletes the table with schema
and records but truncate deletes only records.Drop can be
roll back but not truncate.

Is This Answer Correct ?

7 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is co-related sub query?

975

Can two tables have the same primary key?

1133

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

914

What do you understand by a view?

933

What is difference between delete & truncate commands?

1023

What are the functions in sql server?

901

What is updatable resultset?

936

How to get a list all databases on the sql server?

1026

What is a data source or ds? : sql server analysis services, ssas

948

What is read uncmmited?

1011

What are the differences between char and nchar in ms sql server?

1008

how would you store your query in an SSRS report or a Database server?

152

What is unpivot?

968

What is policy based management (pbm)? : sql server database administration

928

What is a constant or literal in ms sql server?

991