Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37611 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
Define synonym?
How to enable/disable indexes?
Is it possible to have clustered index on separate drive from original table location?
How to resolve the orphan use problem? : sql server security
What stored procedure would you use to view lock information?
How to change parameter value inside the report?
Define ACID properties in a Database?
Does group by sort data?
How do indexes help, types?
What is the name of reporting services config file and what’s it’s used for?
Explain about merge replications?
How to verify a login name with sqlcmd tool?
What is the difference between indexing and hashing?
Can we do dml on views?
What is bookmark link in ssrs?
