Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38440 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / ferolin j
DROP TABLE- all the relationships with other tables will
no longer be valid, the integrity constraints will be
dropped, grant or access privileges on the table will also
be dropped, if want use the table again it has to be
recreated with the integrity constraints, access privileges
and the relationships with other tables should be
established again.
TRUNCATE TABLE- the table structure remains the same, ONLY
deletes the data.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is forward - only cursors / read only cursor?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is a partitioned view?
What is the difference between left and right outer join?
Can I save my report as html, excel or word? : sql server management studio
What is the contrast between sql and mysql?
How to write a query with a full outer join in ms sql server?
How sql server enhances scalability of the database system?
How can you ensure that the database and sql server based application perform well?
What is the use of nvl work?
What is the use of RDBMS?
What is stretch database in sql server?
How do you create an execution plan?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What are “unrepeatable reads”?
