Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE, TRUNCATE, and DROP?
- 3 Answers
- 1396 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
Can we insert data into materialized view?
What is sqlerrd?
Is pl sql a programming language?
what is bcp? When does it used? : Sql dba
List the ways to get the count of records in a table?
Which one is better subquery or joins?
Can we use joins in subquery?
what happens if null values are involved in expressions? : Sql dba
Is sql workbench free?
How do you optimize a query?
Is microsoft sql free?
What do you mean by rowid?
What is cross join sql?
How can you load multi line records? : aql loader
Explain what is a column in a table?
