# SHOW PROCEDURES

Lists existing stored procedures in the current or the specified database.

Refer to [Permissions Matrix](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permission.

## Syntax

```sql
SHOW PROCEDURES [{FROM | IN} database_name] [LIKE pattern]
```

## Remarks

* The `Routine Lifetime` column in the output specifies if the stored procedure is temporary or permanent (non-temporary). Refer to [CREATE TEMPORARY PROCEDURE](https://docs.singlestore.com/cloud/reference/sql-reference/procedural-sql-reference/create-or-replace-temporary-procedure.md) for information on temporary stored procedures.
* The `Definer` column in the output specifies the user that created the stored procedure in the `'username'@'hostname'` format.

## Example - List Stored Procedures

The following examples show how to list stored procedures:

* List all the stored procedures in the current database:
  ```sql
  SHOW PROCEDURES;

  ```
  ```output

  +----------------------+------------------+---------+
  | Procedures_in_dbTest | Routine Lifetime | Definer |
  +----------------------+------------------+---------+
  | charge_account       | Permanent        | userA@% |
  | courses_sp           | Permanent        | userA@% |
  | temp_sp1             | Temporary        | userA@% |
  +----------------------+------------------+---------+
  ```
* List stored procedures in the specified database:
  ```sql
  SHOW PROCEDURES IN dbExample;

  ```
  ```output

  +-------------------------+------------------+---------+
  | Procedures_in_dbExample | Routine Lifetime | Definer |
  +-------------------------+------------------+---------+
  | sp1                     | Permanent        | userA@% |
  | sp2                     | Permanent        | userA@% |
  | test_sp                 | Permanent        | userA@% |
  | ticket_sales_by_minute  | Permanent        | userA@% |
  | test_sp                 | Temporary        | userA@% |
  +-------------------------+------------------+---------+
  ```
* List the stored procedures that match a specified pattern in the current database:
  ```sql
  SHOW PROCEDURES LIKE '%sp%';

  ```
  ```output

  +-----------------------------+------------------+---------+
  | Procedures_in_dbTest (%sp%) | Routine Lifetime | Definer |
  +-----------------------------+------------------+---------+
  | courses_sp                  | Permanent        | userA@% |
  | temp_sp1                    | Temporary        | userA@% |
  +-----------------------------+------------------+---------+

  ```

***

Modified at: March 16, 2026

Source: [/cloud/reference/sql-reference/procedural-sql-reference/show-procedures/](https://docs.singlestore.com/cloud/reference/sql-reference/procedural-sql-reference/show-procedures/)

(An index of the documentation is available at /llms.txt)