What is the difference between Drop and Truncate
Answer Posted / swathi
drop will remove the entire table from the database and can
be rollbacked.
truncate will remove the content of the table and it cannot
be rollbacked.
truncate is little bit faster than drop.
Is This Answer Correct ? | 4 Yes | 14 No |
Post New Answer View All Answers
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What is onf in normalization form?
Why do we need different type of parameter?
What are the different types of collation sensitivity?
What is a covered index?
Explain the creation and execution of a user-defined function in the sql server?
Can we perform backup restore operation on tempdb?
What are the different types of locks in the database?
What is difference between unique and primary key?
What is the web service used for reporting services?
Explain about thread and memory management process of SQL?
System variable and temporary variables
How do we Backup SQL Azure Data?
Explain datetimeoffset data type in sal server 2008?
What are .mdf files?