What is the difference between DELETE, TRUNCATE, and DROP?
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 is set serveroutput on in pl sql?
what is acid property in database? : Sql dba
How to connect a sql*plus session to an oracle server?
What is the difference between delete, truncate and drop command?
What is the difference between a primary key and a unique key?
What is the difference between drop and truncate commands?
What is cursor and why it is required?
how are mysql timestamps seen to a user? : Sql dba
What are the different type of joins in sql?
What is the difference between cross join and natural join?
How do I get sql certification?
What is the difference between left join and right join?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What are sql queries used for?
How many rows can sqlite handle?