What is the difference between Drop and Truncate

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to select some specific rows from a table in ms sql server?

822


What is a DBMS, query, SQL?

857


How sql server enhances scalability of the database system?

842


How to drop existing indexes in ms sql server?

811


What are subquery and its properties?

786


Is BCNF better than 2NF & 3NF? Why?

853


What is inner join? Explain with an example?

925


What are the 7 disadvantages to a manual system?

738


Explain about Joins?

804


What is the process of normalising?

805


What are the underflow and overflow behaviors on float literals?

867


What is the advantage of sql server?

831


What were the latest updates to SQL Azure service?

104


What is meant by Active-Passive and Active-Active clustering setup?

809


Explain what are the database objects? : SQL Server Architecture

819