Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 24977 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 is sorting in sql?
Which normal form is best?
Explain the insert into statements in sql?
Why do we go for stored procedures?
Enlist some predefined exceptions?
What is database migration?
Which command is used to call a stored procedure?
What is write ahead logging in sql server?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
Define overloaded procedure?
what is rdbms? : Sql dba
What are the two characteristics of a primary key?
what are myisam tables? : Sql dba
Why use stored procedures?
What is sqlexception in java?
