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

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

Shows the content of one or all existing
[SQL procedures](/content/sql/procedure/create-procedure#sql-procedures-create).

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

## Parameters

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

  <Accordion title="<procedure name>" id="<procedure-name>" defaultOpen>
    Name of the *procedure* whose content will be output; use `*` instead of
    *schema*/*procedure* name to output the DDL of all *procedures*.
  </Accordion>
</AccordionGroup>

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