---
title: "DataSourceInformation (SQL Server)"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/sqlserver/Database.Metadata.DataSourceInformation
original: https://documentation.invantive.eu/en/datamodels/sqlserver/Database.Metadata.DataSourceInformation
updated: 2026-11-18T23:25:39Z
license: https://documentation.invantive.eu/en/
---

# DataSourceInformation: SQL Server

`read only`

- Catalog: `Database`
- Schema: `Metadata`

Can only retrieve data.

## Table Columns

The columns of the table `DataSourceInformation` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `COMPOSITE_IDENTIFIER_SEPERATOR_PATTERN` | `varchar2(240)` | Composite Identifier Separator Pattern | [ ] |  |  |
| `GROUP_BY_BEHAVIOR` | `int32` | Group by Behavior | [ ] |  |  |
| `IDENTIFIER_CASE` | `int32` | Identifier Case | [ ] |  | 0: Unknown, the data source has ambiguous rules regarding identifier case and cannot discern this information; 1: Insensitive; the data source ignores identifier case when searching the system catalog. The identifiers "ab" and "AB" will match; 2: Sensitive; the data source distinguishes identifier case when searching the system catalog. The identifiers "ab" and "AB" will not match. |
| `IDENTIFIER_PATTERN` | `varchar2(240)` | Identifier Pattern | [ ] |  |  |
| `ORDER_BY_COLUMNS_IN_SELECT` | `char` | Order by Columns in Select | [ ] |  |  |
| `PARAMETER_MARKER_FORMAT` | `varchar2(240)` | Parameter Marker Format | [ ] |  |  |
| `PARAMETER_MARKER_PATTERN` | `varchar2(240)` | Parameter Marker Pattern | [ ] |  |  |
| `PARAMETER_NAME_MAX_LENGTH` | `int32` | Parameter Name Maxmimum Length | [ ] |  |  |
| `PARAMETER_NAME_PATTERN` | `varchar2(240)` | Parameter Name Pattern | [ ] |  |  |
| `PRODUCT_NAME` | `varchar2(240)` | Product Name | [ ] |  |  |
| `PRODUCT_VERSION` | `varchar2(240)` | Product Version | [ ] |  |  |
| `PRODUCT_VERSION_NORMALIZED` | `varchar2(240)` | Product Version Normalized | [ ] |  |  |
| `QUOTED_IDENTIFIER_CASE` | `varchar2(240)` | Quoted Identifier Case | [ ] |  |  |
| `QUOTED_IDENTIFIER_PATTERN` | `varchar2(240)` | Quoted Identifier Pattern | [ ] |  |  |
| `STATEMENT_SEPARATOR_PATTERN` | `varchar2(240)` | Statement Separator Pattern | [ ] |  |  |
| `STRING_LITERAL_PATTERN` | `varchar2(240)` | String Literal Pattern | [ ] |  |  |
| `SUPPORTED_JOIN_OPERATORS` | `int32` | Supported Join Operators | [ ] |  |  |

