What is the difference between Drop and Truncate
Answer Posted / antim
both are ddl commands.Drop deletes the table with schema
and records but truncate deletes only records.Drop can be
roll back but not truncate.
| Is This Answer Correct ? | 7 Yes | 9 No |
Post New Answer View All Answers
What are partitioned views?
Define Wed Edition in SQL Azure?
What does select 1 mean?
What is sql server agent and what are the two modes of authentication in sql server?
Can We Use Data-grids For Our Report In Ssrs?
What type of locking occurs during the snapshot generation? : sql server replication
what are cursors? : Sql server database administration
What is scan table/view and seek table/view when its occurs? : sql server database administration
Explain about extended stored procedure?
Can two different columns be merged into single column? Show practically?
What is transaction server consistency?
What is an indexed view?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is sql server used for?
What are the types of subquery?