What is the difference between Drop and Truncate
Answer Posted / mohsin mohammed abdul
Drop means removing the existing object from the database.
turncate means you are deleting the data from the table and
oracle implicitly issues commit statment and even when you
say rollback , you won't get the data back due to commit ..
| Is This Answer Correct ? | 36 Yes | 12 No |
Post New Answer View All Answers
Ms sql server index?
Do you know what is normalization of database? What are its benefits?
Mention the differences between sql server and mysql.
How to transfer a table from one schema to another?
How to include date and time values in sql statements?
What does ss stand for sexually?
Explain the properties of the relational tables?
What is collation?
Do you know exporting and importing utility?
Is null in sql server?
What is deploy, process and build? : sql server analysis services, ssas
Some queries related to SQL
Can we install sql server 2016 on windows 7?
What do you mean by an execution plan? How would you view it?
how can a database be repaired? : Sql server administration