> ## 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 DATA SOURCE

<a id="sql-drop-data-source" />

Removes an existing [data source](/content/sql/ddl/create-data-source#sql-create-data-source).

```sql title="DROP DATA SOURCE Syntax" theme={null}
DROP [EXTERNAL] DATA SOURCE [<schema name>.]<data source name>
```

<Info>
  Any [external tables](/content/sql/ddl/create-external-table#sql-create-ext-table) or
  subscriptions initiated by a [LOAD INTO](/content/sql/load#sql-load-into) command that depend
  on a given *data source* must be dropped before it can be dropped.
</Info>

## Parameters

<AccordionGroup>
  <Accordion title="EXTERNAL" id="external" defaultOpen>
    Optional keyword for clarity
  </Accordion>

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

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

## Examples

To drop a *data source*, `kin_ds`:

```sql DROP DATA SOURCE Example theme={null}
DROP DATA SOURCE kin_ds
```