Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37645 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 the different topologies in which replication can be configured?
What are the different normalization forms?
How do you handle datasets larger than 50 gb?
What is nolock?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Tell me what is the significance of null value and why should we avoid permitting null values?
Please illustrate physical database architecture? : SQL Server Architecture
How to automatically create a log when an exception is being received into SQL Server?
What is a transact-sql statement?
What does select 1 mean?
How can you fetch alternate records from a table?
Are all views updatable ?
tell me the disaster recovery plan
Explain how many types of relationship?
What are the differences between char and nchar in ms sql server?
