Learn to analyze data with SQL and prepare for technical interviews.

Analyze Data with SQL

In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.

Learn SQL


The **`DROP TABLE`** command deletes an existing table in a [database](https://www.codecademy.com/resources/docs/general/database).

## Syntax

```pseudo
DROP TABLE table_name;
```

The above command removes the `table_name` table from a database.

## Example

```sql
DROP TABLE students;
```

This example removes the `students` table from a database.


ALTER TABLE

CASE

CREATE INDEX

CREATE TABLE

CREATE VIEW

DELETE

DROP TABLE

FULL OUTER JOIN

GROUP BY

HAVING

INNER JOIN

INSERT INTO

LEFT JOIN

LIMIT

ORDER BY

RIGHT JOIN

ROUND

SELECT

SELECT DISTINCT

SELECT TOP

UNION

UPDATE

WHERE

WITH

SQL Terms

Back to SQL

DROP TABLE

Syntax

Example

All contributors

Learn SQL on Codecademy

Analyze Data with SQL

Learn SQL

Resources

Support

Resources

Support

Plans

Community

Subjects

Languages

Career building

Mobile

Mobile