Skip to main content
show_sql_proc(procedure_name=”, options=)[source]

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

Parameters

procedure_name (str) –

Name of the procedure for which to retrieve the information. If blank, then information about all procedures is returned. The default value is ‘’.

options (dict of str to str) –

Optional parameters. Allowed keys are:

  • 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. Allowed values are:

    • true

    • false

    The default value is ‘false’.

The default value is an empty dict ( ).

Returns

A dict with the following entries–

procedure_names (list of str) –

A list of the names of the requested procedures.

procedure_definitions (list of str) –

A list of the definitions for the requested procedures.

additional_info (list of dicts of str to str) –

Additional information about the respective tables in the requested procedures. Allowed keys are:

  • execute_as – The periodic execution impersonate user. The default value is ‘’.

  • execute_interval – The periodic execution interval in seconds. The default value is ‘’.

  • execute_start_time – The initial date/time that periodic execution began. The default value is ‘’.

  • execute_stop_time – Time at which the periodic execution stops. The default value is ‘’.

info (dict of str to str) –

Additional information.