What is the difference between Drop and Truncate
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
What is the security model used in sql server 2005?
How to skip remaining statements in a loop block using continue statements?
query processing
What is the difference between stored procedure and user defined functions?
How many databases instances are there in sql server 2000?
How to create a view with data from multiple tables?
What are the differences between user defined functions and stored procedures?
How to enforce security in sql server? : sql server security
Define ACID properties in a Database?
Where the sql logs gets stored?
What is the recommended total size of your memory optimized tables?
What are the advantages of log shipping?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What are the different types of stored procedures?
How to see existing views in ms sql server?