What is difference between TRUNCATE & DELETE?
Answer Posted / amedela chandra sekhar
Truncate Delete
1)it is DDl command it is DML command
2)it delete records permanently it delete records temporarly
we can't roll back we can roll back the data
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the requirement of self-join?
What is meant by truncate in sql?
Does inner join return duplicate rows?
What is procedure explain with example?
Can we delete column in sql?
How do I install microsoft sql?
What is pragma in sql?
what are all the common sql function? : Sql dba
What does an inner join do?
How do I view a view in sql?
What is embedded sql what are its advantages?
what is the use of set statement in tsql? : Transact sql
What is foreign key sql?
How do I remove sql plus from windows 10?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10