Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE, TRUNCATE, and DROP?
- 3 Answers
- 1566 Views
- I also Faced
- E-Mail Answers
Answer Posted / nashiinformaticssolutions
• 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
What are different types of triggers?
How to return an array from java to pl/sql?
What is java sql connection?
What is the purpose of normalization?
Are sql database names case sensitive?
What will you get by the cursor attribute sql%found?
What is trigger explain it?
Why trigger is used in sql?
What does pragma mean?
How do you bind variables in pl sql?
What is rank function in sql?
What are the types of keys?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Why use triggers in sql?
what is query cache in mysql? : Sql dba
