SQL DROP Command Explained With Examples

The DROP command in a database is used to delete objects such as tables, indexes, stored procedures, and views. The usage is as follows:

1. remove table

DROP TABLE table_name;

1. Delete the index.

DROP INDEX index_name ON table_name;

1. Delete the stored procedure.

DROP PROCEDURE procedure_name;

1. Delete view:

DROP VIEW view_name;

It is important to note that the DROP command is irreversible, once executed it cannot be undone. Therefore, before executing the DROP command, make sure to back up any data that needs to be preserved.