Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25112 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / anitha
If we are using the delete command means the content of the
table will be deleted.but we can recover that data by using
the roll back query in my sql.
But this one is not possible we can use truncate.so some
times of our carelessness we can loss some valuable and
sensitive datas.
so make sure of that before using truncate...
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the key differences between SQL and PL SQL?
What are primary key and foreign key and how they work?
What are all different types of collation sensitivity?
What are the indexing methods?
What's the difference between a primary key and a clustered index?
What is the syntax to add a record to a table?
What is cte sql?
What is set transaction?
What is a data definition language?
What is graph sql?
What do you mean by “trigger” in sql?
What is sql basics?
What are the benefits of pl sql?
what is a constraint? : Sql dba
What are all the different types of indexes?
