Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE, TRUNCATE, and DROP?
- 3 Answers
- 1693 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
Where is all the data on the internet stored?
how to calculate expressions with sql statements? : Sql dba
What is t sql used for?
Give the order of sql select?
What is coalesce in sql?
how many groups of data types? : Sql dba
Why do we create stored procedures & functions in pl/sql and how are they different?
What is localdb mssqllocaldb?
Why do we need view in sql?
Is sql considered coding?
The select into statement is most often used to create backup copies of tables or for archiving records?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is sql deadlock?
what is sql? : Sql dba
What is crud stand for?
