DataSourceInformation schema collection returns information about the Advanced SQL Engine associated with the current open connection.

Column Name	Data Type	Description
CompositeIdentifierSeparatorPattern	String	The regular expression to match the composite separators in a composite identifier. This field is set to \. . A composite identifier is typically what is used for a object name, for example DBC.TABLES.TABLENAME. The SQL Engine supports FULLSTOP (also known as period) character as separator.
DataSourceProductName	String	The name of the product accessed by the provider. This field is set to Teradata.
DataSourceProductVersion	String	Indicates the version of the SQL Engine accessed by the provider.  The format is nn.nn.nn.nn, for example 06.02.00.00.
DataSourceProductVersionNormalized	String	A normalized version for the data source, such that it can be compared with String.Compare(). The format of this is consistent for all versions of the provider to prevent version 10 from sorting between version 1 and version 2. The format is nn.nn.nn.nn, for example 12.00.00.00 .
GroupByBehavior	GroupByBehavior	Specifies the relationship between the columns in a GROUP BY clause and the non-aggregated columns in the select list. This field is set to MustContainAll ("The GROUP BY clause must contain all nonaggregated columns in the select list, and can contain other columns not in the select list").
IdentifierPattern	String	A regular expression that matches an identifier and has a match value of the identifier. This field is set to (^[a-zA-Z_#\$][a-zA-Z0-9_#\$]{0,29}$)|(^"([^"]|""){1,30}"$) . Note that it is designed to match an identifier not an SQL statement containing one or more Identifiers.
IdentifierCase	IdentifierCase	Indicates whether non-quoted identifiers are treated as case sensitive or not. This field is set to Insensitive.
OrderByColumnsInSelect	Boolean	Specifies whether columns in an ORDER BY clause must be in the select list. This field is set to false indicating that they are not required to be in the select list.
ParameterMarkerFormat	String	A format string that represents how to format a parameter. The SQL Engine does not support Named Parameters. Therefore this field is set to ? . In another word Parameterized Queries are of the form "SELECT Col1, Col2 From Tab1 Where Col3 = ?".
ParameterMarkerPattern	String	A regular expression that matches a parameter marker. It will have a match value of the parameter name, if any. The SQL Engine does not support Named Parameters. Therefore this field is set to \?.
ParameterNameMaxLength	Int32	The maximum length of a parameter name in characters. If the data source does not support named parameters, this property returns zero. The SQL Engine does not support Named Parameters. This field is set to ZERO.
ParameterNamePattern	String	A regular expression that matches the valid parameter names. The SQL Engine does not support Named Parameters. Therefore this field is Empty.
QuotedIdentifierPattern	String	A regular expression that matches a quoted identifier and has a match value of the identifier itself without the quotes. This field is set to "(([^"]|"")*)" .
QuotedIdentifierCase	IdentifierCase	Indicates whether quoted identifiers are treated as case sensitive or not. This field is set to Insensitive.
StatementSeparatorPattern	String	A regular expression that matches the statement separator. This field is set to ; . In another word, the semicolon separates statements in a multi-statement request.
StringLiteralPattern	String	A regular expression that matches a string literal and has a match value of the literal itself. This field is set to '(([^']|'')*)' .
SupportedJoinOperators	SupportedJoinOperators	Specifies what types of SQL join statements are supported by the data source. This field is set to FullOuter, Inner, LeftOuter and RightOuter .