What is the difference between Drop and Truncate
- 20 Answers
- 32070 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / vishant kakwani
drop is delete the data with table and if id is used as autoincrement then id can't be started with 1.
Truncate is delete the only data table as it is and autoincrement id will started with 1 every time if you truncate the table.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Ms sql server index?
What is difference between unique and primary key?
Is INSTEAD OF trigger directly applicable to Table ?
Mention the differences between local and global temporary tables.
Explain various On-Delete options in a DB table. Which is the default option?
What is #temp and @table variable in SQL server?
What are the differences between triggers and stored procedures?
What is difference between table aliases and column aliases? Do they affect performance?
What is the downside of using udf?
Does partitioning help performance?
How to generate create view script on an existing view?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Do you know what are acid properties of transaction?
How to connect php with different port numbers?
what data regions are and what are the different data regions?
