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
How to select some specific rows from a table in ms sql server?
What is a DBMS, query, SQL?
How sql server enhances scalability of the database system?
How to drop existing indexes in ms sql server?
What are subquery and its properties?
Is BCNF better than 2NF & 3NF? Why?
What is inner join? Explain with an example?
What are the 7 disadvantages to a manual system?
Explain about Joins?
What is the process of normalising?
What are the underflow and overflow behaviors on float literals?
What is the advantage of sql server?
What were the latest updates to SQL Azure service?
What is meant by Active-Passive and Active-Active clustering setup?
Explain what are the database objects? : SQL Server Architecture