Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38399 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
What are data resources?
Explain where clause?
what is create database syntax? : Sql server database administration
What is an index in sql?
How do you debug a procedure in sql server?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Explain error and transaction handling in sql server?
What is replication with database mirroring? : sql server database administration
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What are sql servers used for?
What stored by the model?
How to get a list of columns in a view using the "sp_columns" stored procedure?
How many triggers are possible per table?
Define msdb database?
What is a database table?
