Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37032 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 is the advantage of sql server?
What happens if an integer is too big for int date type?
What are the diifferences between the ms sql server vs mysql?
What is tempdb database? : SQL Server Architecture
Explain what you mean by 3 tier architecture.
What are the different type of replication in sql server?
What is the language structure to add a record to a table?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is the meaning of sql server?
How do I find information about the install locations for the various instances running on a computer?
What is the sql profiler?
What command do we use to rename a db, a table and a column?
How do I find the sql server instance name?
What is the difference between clustered index and primary key?
What are sub reports and how to create them?
