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

# SHOW PROCEDURE

Shows the content of one or all existing
[SQL procedures](https://docs.kinetica.com/content/sql/procedure/create-procedure.md#sql-procedures-create).

```sql title="SHOW PROCEDURE Syntax" theme={null}
SHOW PROCEDURE < [<schema name>.]<procedure name> | * >
```

## Parameters

> [accordion] \<schema name>
>
> Name of the *schema* containing the *procedure* to show.

> [accordion] \<procedure name>
>
> Name of the *procedure* whose content will be output; use `*` instead of
> *schema*/*procedure* name to output the DDL of all *procedures*.

## Examples

To show the contents of the `sqlp_weekly` *SQL procedure*:

```sql SHOW PROCEDURE Example theme={null}
SHOW PROCEDURE example.sqlp_weekly
```

To output the DDL for all *SQL procedures*:

```sql SHOW PROCEDURE (All SQL Procedures) Example theme={null}
SHOW PROCEDURE *
```


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