---
title: "DROP ROUTINE"
source: https://cloudberry.apache.org/docs/sql-stmts/drop-routine
---

# DROP ROUTINE

Removes a routine.

## Synopsis

```sql
DROP ROUTINE [IF EXISTS] name ( [ [argmode] [argname] argtype [, ...] ] )
    [CASCADE | RESTRICT]
```

## Description

`DROP ROUTINE` removes the definition of an existing routine, which can be an aggregate function, a normal function, or a procedure. Refer to [DROP AGGREGATE](/docs/sql-stmts/drop-aggregate.md), [DROP FUNCTION](/docs/sql-stmts/drop-function.md), and [DROP PROCEDURE](/docs/sql-stmts/drop-procedure.md) for the description of the parameters, more examples, and further details.

## Examples

To drop the routine `foo` for type `integer`:

```sql
DROP ROUTINE foo(integer);
```

This command will work independent of whether `foo` is an aggregate, function, or procedure.

## Compatibility

This command conforms to the SQL standard, with these Apache Cloudberry extensions:

- The standard only allows one routine to be dropped per command.

- The `IF EXISTS` option.

- The ability to specify argument modes and names.

- Aggregate functions are an extension.

## See also

[DROP AGGREGATE](/docs/sql-stmts/drop-aggregate.md), [DROP FUNCTION](/docs/sql-stmts/drop-function.md), [DROP PROCEDURE](/docs/sql-stmts/drop-procedure.md), [ALTER ROUTINE](/docs/sql-stmts/alter-routine.md)