Common Schema Collections

The common schema collections are available for all .NET Framework managed providers. ODP.NET supports the same common schema collections.

MetaDataCollections

Table A-1 is a list of metadata collections that is available from the data source, such as tables, columns, indexes, and stored procedures.

Table 1 MetaDataCollections

Column Name Data Type Description
CollectionName string The name of the collection passed to the GetSchema method for retrieval.
NumberOfRestrictions int Number of restrictions specified for the named collection.
NumberOfIdentifierParts int Number of parts in the composite identifier/database object name.

DataSourceInformation

Table A-2 lists DataSourceInformation information which may include these columns and possibly others.

Table 2 DataSource Information

Columns Data Type Description
CompositeIdentifierSeparatorPattern string Separator for multipart names: @ | \ .
DataSourceProductName string Database name: Oracle
DataSourceProductVersion string Database version. Note that this is the version of the database instance currently being accessed by DbConnection.
DataSourceProductVersionNormalized string {::nomarkdown}<p>A normalized DataSource version for easier comparison between different versions. For example:</p><p>DataSource Version:
10.2.0.1.0</p><p>Normalized DataSource Version: 10.02.00.01.00</p> {:/}    
GroupByBehavior GroupByBehavior An enumeration that indicates the relationship between the columns in a GROUP BY clause and the non-aggregated columns in a select list.
IdentifierPattern string Format for a valid identifier.
IdentifierCase IdentifierCase An enumeration that specifies whether or not to treat non-quoted identifiers as case sensitive.
OrderByColumnsInSelect bool A boolean that indicates whether or not the select list must contain the columns in an ORDER BY clause.
ParameterMarkerFormat string A string indicating whether or not parameter markers begin with a special character.
ParameterMarkerPattern string The format of a parameter marker.
ParameterNameMaxLength int Maximum length of a parameter.
ParameterNamePattern string The format for a valid parameter name.
QuotedIdentifierPattern string The format of a quoted identifier.
QuotedIdentifierCase IdentifierCase An enumeration that specifies whether or not to treat quote identifiers as case sensitive.
StringLiteralPattern string The format for a string literal.
SupportedJoinOperators SupportedJoin Operators An enumeration indicating the types of SQL join statements supported by the data source.

DataTypes

Table A-3 lists DataTypes Collection information which may include these columns and possibly others. Note: As an example, the description column includes complete information for the TIMESTAMP WITH LOCAL TIME ZONE data type.

Table 3 Data Types

ColumnName Data Type Description
TypeName string

The provider-specific data type name.

Example: TIMESTAMP WITH LOCAL TIME ZONE
ProviderDbType int

The provider-specific type value.

Example: 124
ColumnSize long

The length of a non-numeric column or parameter.

Example:27
CreateFormat string

A format string that indicates how to add this column to a DDL statement.

Example: TIMESTAMP({0} WITH LOCAL TIME ZONE)
CreateParameters string

The parameters specified to create a column of this data type.

Example: 8
DataType string

The .NET type for the data type.

Example: System.DateTime
IsAutoIncrementable bool

A boolean value that indicates whether or not this data type can be auto-incremented.

Example: false
IsBestMatch bool

A boolean value that indicates whether or not this data type is the best match to values in the DataType column.

Example: false
IsCaseSensitive bool

A boolean value that indicates whether or not this data type is case-sensitive.

Example: false
IsFixedLength bool

A boolean value that indicates whether or not this data type has a fixed length.

Example: true
IsFixedPrecisionScale bool

A boolean value that indicates whether or not this data type has a fixed precision and scale.

Example: false
IsLong bool

A boolean value that indicates whether or not this data type contains very long data.

Example: false
IsNullable bool

A boolean value that indicates whether or not this data type is nullable.

Example: true
IsSearchable bool

A boolean value that indicates whether or not the data type can be used in a WHERE clause with any operator, except the LIKE predicate.

Example: true
IsSearchableWithLike bool

A boolean value that indicates whether or not this data type can be used with the LIKE predicate.

Example: false
IsUnsigned bool A boolean value that indicates whether or not the data type is unsigned.
MaximumScale short The maximum number of digits allowed to the right of the decimal point.
MinimumScale short The minimum number of digits allowed to the right of the decimal point.
IsConcurrencyType bool

A boolean value that indicates whether or not the database updates the data type every time the row is changed and the value of the column differs from all previous values.

Example: false
MinimumVersion String

The earliest version of the database that can be used.

Example:09.00.00.00.00
IsLiteralSupported bool

A boolean value that indicates whether or not the data type can be expressed as a literal.

Example: true
LiteralPrefix

string

The prefix of a specified literal.

Example: TO_TIMESTAMP_TZ('
LiteralSuffix string

The suffix of a specified literal.

Example: ','YYYY-MM-DD HH24:MI:SS.FF')

Restrictions

Table A-4 lists Restrictions, including the following columns.

Table 4 Restrictions

ColumnName Data Type Description
CollectionName string The collection that the restrictions apply to.
RestrictionName string The restriction name.
RestrictionNumber int A number that indicates the location of the restriction.

ReservedWords

The ReservedWords collection exposes information about the words that are reserved by the database currently connected to ODP.NET. Table A-5 lists the ReservedWords Collection.

Table 5 ReservedWords

ColumnName Data Type Description
ReservedWord string Provider-specific reserved words