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 / 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
Why do we use procedures?
How delete a row in sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is denormalization in a database?
How many columns should be in an index?
Why is pl sql needed?
Differentiate pl/sql and sql?
what is bcp? When does it used? : Sql dba
What are the types of join in sql?
What are its different types of dbms?
What are the built in functions of sql?
What is dcl in sql?
What are all the common sql functions?
Are stored procedures faster than dynamic sql?
Why do we use joins?
