Q. Differentiate between delete and drop command in SQL.
Answers
Answered by
8
Answer:
The DROP command removes a table from the database. All the tables' rows, indexes, and privileges will also be removed. ... DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.
Brainliest plz and follow me plz.
Explanation:
Answered by
4
The DROP command removes a table from the database.
All the tables' rows, indexes, and privileges will also be removed.
No DML triggers will be fired.
The operation cannot be rolled back.
DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command.
Hope it's helps you ☺️
Similar questions