- SQL Basics
- SQL Introduction
- SQL Syntax
- SQL Sample Database
- SQL SELECT
- SQL WHERE
- SQL ORDER BY
- SQL DISTINCT
- SQL LIMIT
- SQL FETCH
- SQL AND
- SQL OR
- SQL BETWEEN
- SQL IN
- SQL LIKE
- SQL IS NULL
- SQL Comparison Operators
- SQL Logical Operators
- SQL Alias
- SQL CASE
- Joins and Subqueries
- SQL INNER JOIN
- SQL LEFT JOIN
- SQL RIGHT JOIN
- SQL FULL OUTER JOIN
- SQL SELF JOIN
- SQL CROSS JOIN
- SQL Subquery
- SQL Correlated Subquery
- SQL UNION
- SQL INTERSECT
- SQL EXCEPT
- Aggregate Functions
- SQL AVG
- SQL COUNT
- SQL MAX
- SQL MIN
- SQL SUM
- SQL GROUP BY
- SQL HAVING
- SQL ROLLUP
- SQL CUBE
- SQL GROUPING SETS
- Database Management
- SQL CREATE DATABASE
- SQL ALTER DATABASE
- SQL DROP DATABASE
- SQL BACKUP DATABASE
- SQL SHOW DATABASES
- SQL SELECT DATABASE
- Table Management
- SQL CREATE TABLE
- SQL ALTER TABLE
- SQL ADD COLUMN
- SQL DROP COLUMN
- SQL DROP TABLE
- SQL TRUNCATE TABLE
- SQL SHOW TABLES
- SQL RENAME TABLE
- SQL Constraints
- SQL Primary Key
- SQL Foreign Key
- SQL UNIQUE Constraint
- SQL CHECK Constraint
- SQL NOT NULL Constraint
SQL DROP TABLE
The DROP TABLE statement in SQL is used to delete an entire table, including all its data and structure, from the database.
Key Features of SQL DROP TABLE
- Permanently removes the table and its data.
- Cannot be undone unless a backup exists.
- Drops indexes, constraints, and relationships associated with the table.
SQL DROP TABLE Syntax
DROP TABLE table_name;
Example: Dropping a Table
DROP TABLE Employees;
- Deletes the
Employeestable and all its data from the database.
Example: Dropping a Table If It Exists (Safe Drop)
DROP TABLE IF EXISTS Employees;
- Drops the
Employeestable only if it exists, preventing errors.
Example: Dropping Multiple Tables (Some Databases Support This)
DROP TABLE Orders, Customers;
- Deletes both
OrdersandCustomerstables.
Summary
DROP TABLEpermanently removes a table from the database.IF EXISTSprevents errors if the table does not exist.- All data, constraints, and relationships related to the table are lost.
- Always ensure a backup before using this command.