> ## 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/sql/proc

```
URL: http://<db.host>:<db.port>/show/sql/proc
```

Shows information about SQL procedures, including the full definition of each
requested procedure.

## Input Parameter Description

<ParamField body="procedure_name" type="string">
  Name of the procedure for which to retrieve the information. If blank, then information about all procedures is returned.

  The default value is ''.
</ParamField>

<ParamField body="options" type="map of string to strings">
  Optional parameters.

  The default value is an empty map ( \{} ).

  <Expandable title="options">
    <ParamField body="no_error_if_not_exists">
      If *true*, no error will be returned if the requested procedure does not exist.  If *false*, an error will be returned if the requested procedure does not exist.

      The default value is `false`.

      The supported values are:

      * true
      * false
    </ParamField>
  </Expandable>
</ParamField>

## Output Parameter Description

The Kinetica server embeds the endpoint response inside a standard response structure which contains status information and the actual response to the query.  Here is a description of the various fields of the wrapper:

<ResponseField name="status" type="String">
  'OK' or 'ERROR'
</ResponseField>

<ResponseField name="message" type="String">
  Empty if success or an error message
</ResponseField>

<ResponseField name="data_type" type="String">
  'show\_sql\_proc\_response' or 'none' in case of an error
</ResponseField>

<ResponseField name="data" type="String">
  Empty string
</ResponseField>

<ResponseField name="data_str" type="JSON or String">
  This embedded JSON represents the result of the /show/sql/proc endpoint:

  <Expandable title="data_str">
    <ResponseField name="procedure_names" type="array of strings">
      A list of the names of the requested procedures.
    </ResponseField>

    <ResponseField name="procedure_definitions" type="array of strings">
      A list of the definitions for the requested procedures.
    </ResponseField>

    <ResponseField name="additional_info" type="array of maps of string to strings">
      Additional information about the respective tables in the requested procedures.

      <Expandable title="additional_info">
        <ResponseField name="execute_as">
          The periodic execution impersonate user.

          The default value is ''.
        </ResponseField>

        <ResponseField name="execute_interval">
          The periodic execution interval in seconds.

          The default value is ''.
        </ResponseField>

        <ResponseField name="execute_start_time">
          The initial date/time that periodic execution began.

          The default value is ''.
        </ResponseField>

        <ResponseField name="execute_stop_time">
          Time at which the periodic execution stops.

          The default value is ''.
        </ResponseField>
      </Expandable>
    </ResponseField>

    <ResponseField name="info" type="map of string to strings">
      Additional information.
    </ResponseField>
  </Expandable>

  Empty string in case of an error.
</ResponseField>