Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37608 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
Which are the two editions in which SQL Azure database available?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is table level trigger?
What is shrink log file?
What is view in sql?
Do you know what are the reporting services components?
What is filtered index?
Explain optimistic and pessimistic concurrency?
Why do we partition data?
How to drop existing indexes in ms sql server?
Which joins are sql server default?
What is t-sql script to take database offline – take database online.
What is temporal table?
What is the purpose of the tempdb database?
What are the advantages of user-defined functions over stored procedures in sql server?
