---
title: "List Procedures"
method: GET
path: "/procedures"
tags: ["Metadata"]
---

# List Procedures

`GET /procedures`

This operation returns information about available stored procedures for a given schema.

## Query parameters

- `catalogName` string
- `schemaName` string
- `procedureName` string

## Response `200`

OK

- QueryResult
  - `results` ResultSet[], nullable
    - `affectedRows` integer — The number of rows affected by the query, or -1 if not applicable.
    - `schema` ColumnInfo[], nullable
      - `catalogName` string, nullable — The name of the catalog containing the column.
      - `columnLabel` string, nullable — The label of the column.
      - `columnName` string, nullable — The name of the column.
      - `dataType` 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 — The parameter's [data type](/en/API/REST-API#data-types).
      - `dataTypeName` string, nullable — The data type name of the column.
      - `length` integer — The length of the column.
      - `nullable` boolean — Whether the column is nullable.
      - `ordinal` integer — The ordinal position of the column.
      - `precision` integer, nullable — The precision of the column.
      - `scale` integer, nullable — The scale of the column.
      - `schemaName` string, nullable — The name of the schema containing the column.
      - `tableName` string, nullable — The name of the table containing the column.
    - `rows` array[], nullable
      - unknown[]
        - unknown
  - `error` ErrorDetail
    - `code` 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79
    - `message` string, nullable — The error message.

---

[API](https://skmtc.net/cdata/apis/cdata-connect-ai-rest-api-embedded.md) · [All operations](https://skmtc.net/cdata/apis/cdata-connect-ai-rest-api-embedded/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/cdata/cdata-connect-ai-rest-api-embedded/versions/c13133ad66c0/schema)