Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37858 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / meera
Drop: delete all data as well as structure.
Truncate: Delete only the data and resets the auto increment
column to 0.
Delete: Delete the selected or all rows from the table , it
doesn't reset to auto increment .
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can sql server 2016 run on windows 7?
What are the restrictions that views have to follow? : SQL Server Architecture
How to add more data to the testing table in ms sql server?
How to get the number of affected rows?
What are recommended options to be used while using db mirroring? : sql server database administration
What is SQL Azure?
Define views.
What is merge replication?
How to change the password of a login name in ms sql server?
Is INSTEAD OF trigger directly applicable to Table ?
What do you understand by replication in sql server?
What program is used to store the data source file?
How to disable a login name in ms sql server?
How to convert a table data in XML format in sql server?
Explain the microsoft sql server delete command?
