What is the difference between DELETE, TRUNCATE, and DROP?
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
How to process query result in pl/sql?
Explain constraints in sql?
What is sql procedures and functions?
What are the sql commands?
What is anonymous block in sql?
what is single byte over head in oracle..?
Are subqueries faster than joins?
What is the difference between between and in condition operators?
what is top in tsql? : Transact sql
How does index help in query performance?
What is difference between mysql and postgresql?
Can a table contain multiple foreign key’s?
How do you create a db file?
What is the order of sql select?
how to dump a table to a file with 'mysqldump'? : Sql dba