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

Explain sql server authentication modes?

1123

Explain a join?

1062

What does select 1 mean?

921

what is nonclustered index

949

How to create database with physical files specified in ms sql server?

991

Explain filtered indexes?

992

What do you understand by a view?

992

What do you mean by collation recursive stored procedure?

1050

Explain user defined functions?

984

What is the difference between varchar and varchar(max) datatypes?

1063

what are the different types of SSRS reports?

151

Explain what is analysis service repository?

982

What is blocking?

1054

Explain sql server service broker?

970

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

976