Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37065 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
How many types of attribute relationships are there? : sql server analysis services, ssas
How to sort query output in descending order in ms sql server?
What is difference between getdate and sysdatetime in sql server 2008?
How raid can influence database performance?
What are synonyms?
Which Model uses the SET concept
What is the difference between seek predicate and predicate?
What is inner join in sql server joins?
Determine when to use stored procedure to complete sql server tasks?
what is the system function to get current user's user id? : Sql server database administration
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What is primary key index?
what's new in sql server 2016?
What is database replication?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
