Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37025 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / suman kalyan betal
DROP means it's drop the table(with rows,Pk_key, Fk_key and
indexces)from the database.
TRUNCATE do the same as DROP but maintain the Pk_key,
Fk_key and indexces declaration only remove rows.
---by suman kalyan betal (suman_kal@rediffmail.com)
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
How to truncate the log in sql server 2012? : sql server database administration
What is the use of =,==,=== operators?
How you can get the list of largest tables in a database?
How can I check if a view exists in a sql server database?
Is sql server free?
How to execute multiple stored procedures at one time in sql server?
What is row_number () and partition by in sql server?
What is surrogate key? : sql server analysis services, ssas
How to achieve Paging of records in SQL SERVER?
Explain syntax for dropping triggers?
Can I use sql azure as a backup with log shipping or database mirroring?
How does recursive cte works in sql server?
What does executeupdate return?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What happens to a statement batch if there is a compilation error?
