Drop table

sql

DROP TABLE old_logs;

Explanation

Be careful: dropping a table deletes its data. Some engines support IF EXISTS.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing CREATE, ALTER, and DROP

Define a new table with columns and constraints.

Open In sheetsqlsame section

Modify an existing table by adding a new column.

Open In sheetsqlsame section

Remove all rows quickly without dropping the table.

Open In sheetsqlsame section

Attach a foreign key or check constraint after table creation.

Open In sheetsqlsame section

Add an index to improve lookup performance.

Open In sheetsql1 tag match

Mark a column as the main row identifier.