What is the difference between DELETE and TRUNCATE?
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
Why do we need pl sql?
What are local and global Indexes and where they are useful.
Are stored procedures faster than queries?
What is the difference between delete and truncate commands?
what are the different index configurations a table can have? : Sql dba
Write a sql query to find the names of employees that begin with ‘a’?
Can we call dml statement in function?
What is a ddl command?
what is a unique key ? : Sql dba
what is view? : Sql dba
how to drop an existing view in mysql? : Sql dba
What are the different types of constraints?
what is index? : Sql dba
is mysql query is case sensitive? : Sql dba
What is clause?