Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE, TRUNCATE, and DROP?
- 3 Answers
- 1567 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
Why cross join is used?
How many types of triggers exist in pl/sql?
Explain isolation levels. : Transact sql
How do rank () and dense_rank () differ?
What are all the common sql functions?
What is sql dialect?
give the syntax of grant and revoke commands? : Sql dba
Can a primary key be a foreign key?
Can we join more than 2 tables in sql?
how to convert character strings to numeric values? : Sql dba
what is msql? : Sql dba
Which is faster union or join?
What do you think about pl/sql?
Why is sql better than hql?
How do you write a subquery?
