> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/commands/data-definition/drop-table",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference and syntax for the DROP TABLE command.

# DROP TABLE

Deletes a table.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
DROP TABLE [IF EXISTS] <table_name> [CASCADE]
```

## Parameters

| Parameter      | Description                                                                                                                |
| :------------- | :------------------------------------------------------------------------------------------------------------------------- |
| `<table_name>` | The name of the table to be deleted. For external tables, the definition is removed from Firebolt but not from the source. |
| `CASCADE`      | When specified, causes all dependent database objects such as views and aggregating indexes to be dropped also.            |
