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

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/generated/show_sql_proc.rs#L22-L28)
pub async fn [show\_sql\_proc](https://docs.kinetica.com/content/api/rust/gpudb/struct.Kinetica/show-sql-proc.md#method.show_sql_proc)( \&self, procedure\_name: [String](https://doc.rust-lang.org/1.98.1/alloc/string/struct.String.html), ) -> [Result](https://doc.rust-lang.org/1.98.1/core/result/enum.Result.html)\<[ShowSqlProcResponse](https://docs.kinetica.com/content/api/rust/generated/api/struct.ShowSqlProcResponse.md), [KineticaError](https://docs.kinetica.com/content/api/rust/errors/enum.KineticaError.md)>

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

##### Arguments

<ul>
  <li>`procedure_name` - Name of the procedure for which to retrieve the information. If blank, then information about all procedures is returned.</li>
</ul>

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/generated/show_sql_proc.rs#L42-L58)
pub async fn [show\_sql\_proc\_with\_opts](https://docs.kinetica.com/content/api/rust/gpudb/struct.Kinetica/show-sql-proc.md#method.show_sql_proc_with_opts)( \&self, procedure\_name: [String](https://doc.rust-lang.org/1.98.1/alloc/string/struct.String.html), options: [ShowSqlProcRequestOptions](https://docs.kinetica.com/content/api/rust/generated/api/struct.ShowSqlProcRequestOptions.md), ) -> [Result](https://doc.rust-lang.org/1.98.1/core/result/enum.Result.html)\<[ShowSqlProcResponse](https://docs.kinetica.com/content/api/rust/generated/api/struct.ShowSqlProcResponse.md), [KineticaError](https://docs.kinetica.com/content/api/rust/errors/enum.KineticaError.md)>

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

##### Arguments

<ul>
  <li>`procedure_name` - Name of the procedure for which to retrieve the information. If blank, then information about all procedures is returned.</li>
  <li>`options` - The optional parameters; any left unset take the server’s defaults.</li>
</ul>

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/generated/show_sql_proc.rs#L61-L72)
pub async fn [show\_sql\_proc\_raw](https://docs.kinetica.com/content/api/rust/gpudb/struct.Kinetica/show-sql-proc.md#method.show_sql_proc_raw)( \&self, request: &[ShowSqlProcRequest](https://docs.kinetica.com/content/api/rust/generated/api/struct.ShowSqlProcRequest.md), ) -> [Result](https://doc.rust-lang.org/1.98.1/core/result/enum.Result.html)\<[ShowSqlProcResponse](https://docs.kinetica.com/content/api/rust/generated/api/struct.ShowSqlProcResponse.md), [KineticaError](https://docs.kinetica.com/content/api/rust/errors/enum.KineticaError.md)>

Sends a pre-built [`ShowSqlProcRequest`](https://docs.kinetica.com/content/api/rust/generated/api/struct.ShowSqlProcRequest) to the `/show/sql/proc` endpoint.

[Source](https://github.com/kineticadb/kinetica-api-rust/blob/master/crates/gpudb-api/src/generated/show_sql_proc.rs#L76-L88)
pub async fn [show\_sql\_proc\_from\_url](https://docs.kinetica.com/content/api/rust/gpudb/struct.Kinetica/show-sql-proc.md#method.show_sql_proc_from_url)( \&self, url: &[str](https://doc.rust-lang.org/1.98.1/std/primitive.str.html), request: &[ShowSqlProcRequest](https://docs.kinetica.com/content/api/rust/generated/api/struct.ShowSqlProcRequest.md), ) -> [Result](https://doc.rust-lang.org/1.98.1/core/result/enum.Result.html)\<[ShowSqlProcResponse](https://docs.kinetica.com/content/api/rust/generated/api/struct.ShowSqlProcResponse.md), [KineticaError](https://docs.kinetica.com/content/api/rust/errors/enum.KineticaError.md)>

Sends a pre-built [`ShowSqlProcRequest`](https://docs.kinetica.com/content/api/rust/generated/api/struct.ShowSqlProcRequest) to a specific worker URL, bypassing HA head-node selection. Used for multi-head access.


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