Basic Example:DROP DATABAE

DROP DATABASE RetailDB;

DROP TABLE Example

DROP TABLE Orders;

The DROP TABLE command removes an existing table and all the data stored in it. This operation also removes the table's schema (structure).

DROP COLUMN (Available in Some RDBMS)

ALTER TABLE Customer
DROP COLUMN email;

This will remove the email column from the Employees table, along with all the data in that column.

The DROP VIEW command is used to remove a view from the database. A view is essentially a virtual table based on a query.

DROP VIEW CustomerDetails;

This will delete the CustomerDetails view. Note that the underlying data in the base tables is not affected by the dropping of a view.

The DROP INDEX command is used to remove an index from a table. Indexes are used to improve query performance, and removing unnecessary indexes can save space and improve performance during updates and inserts.

DROP INDEX idx_customer_name ON Customer;

This will delete the idx_employee_name index from the Employees table. The table’s data remains intact.

You can use the DROP CONSTRAINT command to remove constraints like Primary Key, Foreign Key, Unique, and Check constraints from a table.)

ALTER TABLE table_name
DROP PRIMARY KEY;

ALTER TABLE Orders
DROP FOREIGN KEY fk_customer_id;

Summary of DROP Command Syntax:

Action	Syntax	
Drop a Database:
DROP DATABASE database_name;
Example: DROP DATABASE RetailDB;

Drop a Table:
DROP TABLE table_name;
Example: DROP TABLE Orders;

Drop a Column:
ALTER TABLE table_name
DROP COLUMN column_name;
Example: ALTER TABLE Employees DROP COLUMN email;

Drop a View:
DROP VIEW view_name;
Example: DROP VIEW EmployeeDetails;

Drop an Index:
DROP INDEX index_name ON table_name;
Example: DROP INDEX idx_employee_name ON Employees;

Drop a Foreign Key:
ALTER TABLE table_name
DROP FOREIGN KEY constraint_name;
Example:
ALTER TABLE Orders
DROP FOREIGN KEY fk_customer_id;

Drop a Primary Key:
ALTER TABLE table_name
DROP PRIMARY KEY;
Example: ALTER TABLE Employees DROP PRIMARY KEY;