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

# DROP TABLE

<a id="sql-drop-table" />

Removes an existing [table](/content/sql/ddl/create-table#sql-create-table).  All dependent
[views](/content/sql/ddl/create-view#sql-create-view),
[materialized views](/content/sql/ddl/create-materialized-view#sql-create-materialized-view),
[streams](/content/sql/ddl/create-stream#sql-create-stream), and
[SQL procedures](/content/sql/procedure#sql-procedures) will be dropped.

```sql title="DROP TABLE Syntax" theme={null}
DROP TABLE [IF EXISTS] [<schema name>.]<table name>
```

<Info>
  Any *tables* with [foreign keys](/content/concepts/tables#foreign-key) that
  target a given *table* must be dropped before it can be dropped.
</Info>

## Parameters

<AccordionGroup>
  <Accordion title="IF EXISTS" id="if-exists" defaultOpen>
    Optional error-suppression clause; if specified, no error will be returned if the given
    *table* does not exist
  </Accordion>

  <Accordion title="<schema name>" id="<schema-name>" defaultOpen>
    Name of the *schema* containing the *table* to remove
  </Accordion>

  <Accordion title="<table name>" id="<table-name>" defaultOpen>
    Name of the *table* to remove
  </Accordion>
</AccordionGroup>