Computer Science, asked by dhanashree16, 7 months ago

Q. Differentiate between delete and drop command in SQL.​

Answers

Answered by aishutsh358
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 llxdevilgirlxll
4

\huge\underline\mathfrak\pink{♡Hy Dude}

\huge\underline\mathfrak\red{♡ Answer♡}

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.

<marquee>

Hope it's helps you ☺️

Similar questions