Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37857 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / tamilarasan sivaraj
DROP:It is used to delete the all structure of the db and
also we cant rollback.
EXAMPLE:Drop table student;
It will show error.No table found.
TRUNCATE:It is used to delete the table of the data and
structure remains,we can able to rollback.
EXAMPLE:truncate table student;
No records found;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain acid?
How to check if stored procedure is running in sql server?
What is the use of for clause?
Can we use max in where clause?
What is shared lock?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What does REVERT do in SQL Server 2005?
What is inline table-value user-defined function?
What is the difference between function and stored procedure in sql server?
What is a document index?
What do you understand by the data quality services in sql server?
What are drillthrough reports?
How can I create a new template for import ? : sql server management studio
How to use clusters?
What do you mean by an execution plan? How would you view it?
