Answer Posted / nandini sett
Both delete and Trunate are DML or Data Manupilating
Language.
Both statements --- Delete table_name and Truncate table
table_name --- deletes all rows.
Truncate Table works faster than delete.
Truncate table does not support where clause and truncate
doe not fire a trigger. When truncate is used the deleted
rows are not entered in transaction log.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is materialized view in sql?
Explain the update statement in sql
What is pl sql record in oracle?
What is a loop in sql?
Can we use having without group by in sql?
What is trigger in pl sql with examples?
what is top in tsql? : Transact sql
What does (+) mean in sql joins?
How do I order columns in sql?
What is mutating error?
How would you convert date into julian date format?
How do I count records in sql?
Does truncate table reset auto increment?
which operator is used in query for pattern matching? : Sql dba
What is the difference between inner join and natural join?
