DataSourceInformation: SQL Server Data Source Information |
Catalog: Database
Schema: Invantive
Label: Data Source Information
This is a read-only view. The SQL Server API may not support changing the data or the Invantive SQL driver for SQL Server does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the SQL Server API.
View Columns
The columns of the view DataSourceInformation are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
COMPOSITE_IDENTIFIER_SEPERATOR_PATTERN |
string(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 |
string(240) |
Identifier Pattern |
☐ |
|
ORDER_BY_COLUMNS_IN_SELECT |
boolean |
Order by Columns in Select |
☐ |
|
PARAMETER_MARKER_FORMAT |
string(240) |
Parameter Marker Format |
☐ |
|
PARAMETER_MARKER_PATTERN |
string(240) |
Parameter Marker Pattern |
☐ |
|
PARAMETER_NAME_MAX_LENGTH |
int32 |
Parameter Name Maxmimum Length |
☐ |
|
PARAMETER_NAME_PATTERN |
string(240) |
Parameter Name Pattern |
☐ |
|
PRODUCT_NAME |
string(240) |
Product Name |
☐ |
|
PRODUCT_VERSION |
string(240) |
Product Version |
☐ |
|
PRODUCT_VERSION_NORMALIZED |
string(240) |
Product Version Normalized |
☐ |
|
QUOTED_IDENTIFIER_CASE |
string(240) |
Quoted Identifier Case |
☐ |
|
QUOTED_IDENTIFIER_PATTERN |
string(240) |
Quoted Identifier Pattern |
☐ |
|
STATEMENT_SEPARATOR_PATTERN |
string(240) |
Statement Separator Pattern |
☐ |
|
STRING_LITERAL_PATTERN |
string(240) |
String Literal Pattern |
☐ |
|
SUPPORTED_JOIN_OPERATORS |
int32 |
Supported Join Operators |
☐ |
|
12-12-2020 18:19 Version 20.1.301-BETA+3023