Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38396 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
What is an example of a primary key?
What is an index in sql?
How do you delete duplicate rows in sql server?
What is the fastest way to permanently delete a 1 million row table named customers?
Explain atomicity?
How many replicas are maintained for each sql azure db?
How many types of local tables are there in sql server?
What do you understand by sql server agent?
What is difference between join and natural join?
Explain the creation and execution of a user-defined function in the sql server?
Define synonym?
What is a trigger? Why we need it?
Explain “not null constraint” in sql server?
How do I find the query plan in sql server?
Explain the commands in sql server?
