Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE, TRUNCATE, and DROP?
- 3 Answers
- 1551 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
How do you declare a constant?
What is the difference between clustered and non-clustered index in sql?
What is scalar function in sql?
What are the different types of sql commands?
What is consistency?
Can we insert data in view?
What are the two virtual tables available at the time of database trigger execution?
What is the use of function in sql?
What is the difference between delete and truncate commands?
Is sql the best database?
What is memory optimized table?
What is a sql profiler?
What are the different ddl commands in sql?
What is the use of procedures?
What does pl sql developer do?
