What is the difference between DELETE, TRUNCATE, and DROP?
Answer Posted / hr@tgksolutions.com
• 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 find 3rd highest salary of an employee from the employee table in sql?
How do I write a cron which will run a sql query and mail the results to agroup?
Can one improve the performance of sql*loader? : aql loader
Can dml statements be used in pl/sql?
What are the string functions in sql?
Why do we need cursors in pl sql?
What is difference between procedure and trigger?
What is the most important ddl statements in sql are?
what are the difference between clustered and a non-clustered index? : Sql dba
What is difference between my sql and sql?
What are pl sql procedures?
How to get list of all tables from a database?
What is the need of a partition key?
What is difference between cursor and trigger?
What is data type in sql?