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 / 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
What is data type in database?
Does truncate require commit?
Is id a reserved word in sql?
What is difference between sql and mysql?
What do you mean by field in sql?
What is procedure explain with program?
What is rowid in sql?
how many values can the set function of mysql take? : Sql dba
how does a local variable is defined using t-sql? : Transact sql
I need a function for a train ticket reservation please answer it thanks in advance
Differentiate between syntax and runtime errors.
What is the main difference between sql and pl/sql?
how to use regular expression in pattern match conditions? : Sql dba
what is a view? : Sql dba
What are the differences between in and exists clause?
