Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38424 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
plss anybody specify tha constrian management system in dbms
What is master database? : SQL Server Architecture
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
How to create a view on an existing table in ms sql server?
What is replace and stuff function in sql server?
What are the differences between DDL, DML and DCL in SQL?
Explain transaction isolation levels in sql server?
Explain about nested stored procedure?
How do I install sql server?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
How to loop through the result set with @@fetch_status?
How optimize sql query with multiple joins in sql server?
What is the importance of a recovery model?
What is a schema in ms sql server 2005?
What are the steps you must follow to hide sql server instances?
