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

# DROP PROCEDURE

The `DROP PROCEDURE` [statement](/docs/stable/sql-statements.md) drops a [stored procedure](/docs/stable/stored-procedures.md).

## Required privileges

To drop a procedure, the user must be the owner of the procedure.

## Synopsis

![drop\_proc syntax diagram](https://mintcdn.com/cockroachlabs/UZNSFbmU2EwEm6G5/images/sql-diagrams/common/drop_proc.svg?fit=max\&auto=format\&n=UZNSFbmU2EwEm6G5\&q=85\&s=98f59223cc9769b03659cfac029ced17)

## Parameters

| Parameter | Description |
| - | - |
| `proc_name` | The name of one of more procedures to drop. |
| `routine_param` | An optional list of the procedure parameters. |

## Examples

### Drop a stored procedure

The following statement drops the [`delete_earliest_histories` example procedure](/docs/stable/stored-procedures):

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
DROP PROCEDURE delete_earliest_histories;
```

## See also

* [Stored Procedures](/docs/stable/stored-procedures.md)
* [PL/pgSQL](/docs/stable/plpgsql.md)
* [`CREATE PROCEDURE`](/docs/stable/create-procedure)
* [`CALL`](/docs/stable/call)
* [`ALTER PROCEDURE`](/docs/stable/alter-procedure)