TRUNCATE: Only data is deleted structure of the table exists. DROP:

What is the difference between Drop and Truncate

Question Posted / koti-khammam

Answer Posted / koti-khammam

TRUNCATE: Only data is deleted structure of the table
exists.

DROP: Both data and structure of the table gets removed.

Is This Answer Correct ?

57 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to test subquery results with the exists operator?

1033

What is user defined stored procedures?

877

How can you fetch alternate records from a table?

913

What is report snapshot in ssrs?

247

What is function of master database?

114

What is reference section?

941

Name and describe few console utilities for ssrs?

275

How can you stop stored procedures from recompiling?

848

explain different types of cursors? : Sql server database administration

1024

Explain differences between web edition and business edition?

119

How to insert a new row into a table with "insert into" statements in ms sql server?

913

What were the latest updates to SQL Azure service?

109

How to change the data type of an existing column with "alter table" statements in ms sql server?

930

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1067

what are different types of raid configurations? : Sql server database administration

994