VOOZH about

URL: https://www.codecademy.com/resources/docs/sql/commands/drop-table

⇱ SQL | Commands | DROP TABLE | Codecademy


Skip to Content

SQL DROP TABLE

Preview: @kazumi_kerr 2 total contributions
@kazumi_kerr

2 total contributions

Published Jan 11, 2023

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 clipboard
Copy 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