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


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.