Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37015 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / mayur jain
Drop means removing.Removing the existence.
Truncate - there is no log maintained for the deleted
records.As when we perform delete a log is maintained a slow
process.
| Is This Answer Correct ? | 27 Yes | 13 No |
Post New Answer View All Answers
Explain the rules for designing files and file groups in sql server?
Can you import Microsoft Excel data to SSRS?
How to create a user name in a database?
What are the recovery models in sql server 2000?
How many triggers you can have on a table?
How does Report Builder support Analysis Services cubes?
What are trace flags and mention a few common trace flags used with sql server?
Explain what is row_number function?
What is policy management?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
Can we use pragma autonomous_transaction in trigger?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
Introduction of rollup clause using sum and group by clause?
What are the steps to insert a table?
How to select some specific rows from a table in ms sql server?
