> ## 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.

> Reference and syntax for the DROP TABLE command.

# DROP TABLE

Deletes a table.

## Syntax

```sql theme={"theme":{"light":"css-variables","dark":"css-variables"}}
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.            |