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_ |
varchar2 |
Composite Identifier Separator Pattern | |||
GROUP_ |
int32 |
Group by Behavior | |||
IDENTIFIER_ |
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_ |
varchar2 |
Identifier Pattern | |||
ORDER_ |
char |
Order by Columns in Select | |||
PARAMETER_ |
varchar2 |
Parameter Marker Format | |||
PARAMETER_ |
varchar2 |
Parameter Marker Pattern | |||
PARAMETER_ |
int32 |
Parameter Name Maxmimum Length | |||
PARAMETER_ |
varchar2 |
Parameter Name Pattern | |||
PRODUCT_ |
varchar2 |
Product Name | |||
PRODUCT_ |
varchar2 |
Product Version | |||
PRODUCT_ |
varchar2 |
Product Version Normalized | |||
QUOTED_ |
varchar2 |
Quoted Identifier Case | |||
QUOTED_ |
varchar2 |
Quoted Identifier Pattern | |||
STATEMENT_ |
varchar2 |
Statement Separator Pattern | |||
STRING_ |
varchar2 |
String Literal Pattern | |||
SUPPORTED_ |
int32 |
Supported Join Operators |