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

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

Removes an existing [SQL procedure](/content/sql/procedure/create-procedure#sql-procedures-create).

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

## Parameters

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

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

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

## Examples

To drop the `sqlp` *SQL procedure*:

```sql DROP PROCEDURE Example theme={null}
DROP PROCEDURE example.sqlp
```


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