invantive documentation
Invantive Support ForumsLog In / Sign Up

DataSourceInformation: SQL Server Data Source Information

read only

  • Catalog: Database
  • Schema: Invantive
  • Label: Data Source Information

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