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

What's new in sql management studio for sql server? : sql server management studio

1118

What is sql server transaction log file?

1104

What is indexing a document?

1087

What are the different types of backups that exist?

1218

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1048

Explain filtered indexes benefits?

1042

How to get the definition of a view out of the sql server?

1027

What is sql service broker?

1020

How to backup encryption key ?

191

What are the fixed server level roles? : sql server security

1216

What is an indexed view?

1006

Distinguish between commit and rollback?

1009

What are the differences between having and where clause.

1016

What stored by the msdb?

1046

How will you optimize a stored procedure optimization?

1112