---
title: "Get ODBC Schema Collection With Restrictions"
slug: "get-odbc-schema-collection-with-restrictions"
tags: ["ODBC", "database", "collection", "restrictions", "schema"]
updated: 2022-12-08T21:13:10Z
published: 2022-12-08T21:13:10Z
canonical: "documentation.decisions.com/get-odbc-schema-collection-with-restrictions"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Get ODBC Schema Collection With Restrictions

| ## Step Details |
| --- |
| **Introduced in Version** | 4.0.0 |
| **Last Modified in Version** | 5.0.0 |
| **Location** | Integration > Database > ODBC |

The **Get ODBC Schema Collection** **With Restrictions** returns the schema information obtained based on the specified restrictions.

---

## Properties

#### Inputs

| Property | Description | Data Type |
| --- | --- | --- |
| Collection Name | Collection name of the ODBC | String |
| Connection String | The connection string of the ODBC | String |
| Restrictions | Limits the number of schema information that is returned. Allows the user to define the Catalog, Owner, Table, and TableType. | ODBCSchemaRestrictions |

#### Outputs

| Property | Description | Data Type |
| --- | --- | --- |
| Output | Schema information | List of Dynamic Data Rows |

#### ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1670532197279.png)

## Related

- [Get Type Name From DBType](/get-type-name-from-dbtype.md)
- [Get View Infos](/get-view-infos.md)