Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38398 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
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
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
How do I port a number to sql server?
What are the extra roles available in msdb? : sql server security
Explain how to maintain a fill factor in existing indexes?
What is the usage of sign function?
Give me a SQL Query to find out the second largest company?
How to recreate an existing index in ms sql server?
Do you know what is a linked server in sql server?
List the different normalization forms?
how can u get last observation in an unknown dataset ?
What are the properties of primary key?
How to run queries with sql server management studio express?
How to create “dependant” parameter “make, model, year”
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is change data capture (cdc) feature?
