Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37614 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / vipin narwal
HI TO ALL!!!
DROP: will lead in deleting the structure of the table
along with all associated constraints like Primary
Key,Foreign Key,..etc and also deallocates the memory
allocated to the Database objects..
Truncate: Truncate like Delete deletes the data associated
with a Database Object but structure remains there i.e,
memory remains allocated,...but faster than Delete...
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Is there any difference between the primary key and unique key?
What is the difference between resultset and resultsetmetadata?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is the difference between join and inner join?
How do you clear a log file?
How many replicas are maintained for each SQL Azure database?
What is normalization 1nf 2nf 3nf?
What happens if null values are involved in boolean operations?
how many type of indexing in database?
How you can get the list of largest tables in a database?
How to use subqueries with the exists operators in ms sql server?
What is difference between materialized view and view?
How to reaname table name without using sp_Rename in sql server..?
What is best institute to Learn DotNET And SQL in chennai?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
