Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE, TRUNCATE, and DROP?
- 3 Answers
- 1701 Views
- I also Faced
- E-Mail Answers
Answer Posted / nashiinformaticssolutions
• 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
Which certification is best for sql?
How do you modify a table in sql?
What is difference between cursor and trigger?
What is the function that is used to transfer a pl/sql table log to a database table?
Which command is used to call a stored procedure?
What are schema-level triggers?
How do I view stored procedures?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is sql*loader and what is it used for? : aql loader
Which join is like an inner join?
Why indexing is needed?
What is a sql trace file?
What are packages in pl sql and also explain its advantages?
What is function and procedure?
What do you understand by exception handling in pl/sql?
