Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE, TRUNCATE, and DROP?
- 3 Answers
- 1398 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 many sql statements are used?
How do I find duplicates in the same column?
What is the difference between sql and t sql?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is the difference between left and left outer join?
Is sql an operating system?
What has stored procedures in sql?
Which sql most popular?
Which one is better subquery or joins?
Explain mutating table error.
What is the difference between execution of triggers and stored procedures?
What is mutating error in pl sql?
What are literals in sql server?
What is the purpose of the partition table?
what is the difference between delete and truncate statement in sql? : Sql dba
