What is the difference between DELETE, TRUNCATE, and DROP?
- 3 Answers
- 714 Views
- I also Faced
- E-Mail Answers
Answer Posted / glibwaresoftsolutions
• DELETE:
o Deletes specific rows from a table.
o Can have a WHERE clause.
o DML command (can be rolled back).
• TRUNCATE:
o Deletes all rows from a table.
o Faster than DELETE (does not log individual row deletions).
o DDL command (cannot be rolled back).
• DROP:
o Removes a table entirely (schema + data).
o DDL command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When sql appeared?
How do you write a subquery?
Is join same as left join?
What is delimiter in pl sql?
What is the difference between inner join and natural join?
What is numeric function sql?
What is trigger explain it?
what are enums used for in mysql? : Sql dba
How do you drop a trigger?
What are sql procedures?
Why we use pl sql?
In what condition is it good to disable a trigger?
What is latest version of sql?
what is a composite key ? : Sql dba
What is where clause in sql?
