SQL DROP TABLE
The DROP TABLE command deletes an existing table in a database.
- Learn to analyze data with SQL and prepare for technical interviews.
- Includes 9 CoursesIncludes 9 Courses
- With CertificateWith Certificate
- Beginner Friendly.17 hours17 hours
- In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.
- Beginner Friendly.5 hours5 hours
Syntax
DROP TABLE table_name;
The above command removes the table_name table from a database.
Example
DROPTABLE students;Copy to clipboardCopy to clipboard
This example removes the students table from a database.
All contributors
Learn SQL on Codecademy
- Learn to analyze data with SQL and prepare for technical interviews.
- Includes 9 CoursesIncludes 9 Courses
- With CertificateWith Certificate
- Beginner Friendly.17 hours17 hours
- In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.
- Beginner Friendly.5 hours5 hours
