OLE DB Schema Collections (ADO.NET)

  • Article

This section discusses schema collection support for the OLE DB providers for Microsoft SQL Server, Oracle, and Microsoft Jet.

Microsoft SQL Server OLE DB Provider

The Microsoft SQL Server OLE DB Driver supports the following specific schema collections in addition to the common schema collections:

  • Tables

  • Columns

  • Procedures

  • ProcedureParameters

  • Catalog

  • Indexes

Tables

ColumnName

DataType

TABLE_CATALOG

String

TABLE_SCHEMA

String

TABLE_NAME

String

TABLE_TYPE

String

TABLE_GUID

Guid

DESCRIPTION

String

TABLE_PROPID

Int64

DATE_CREATED

DateTime

DATE_MODIFIED

DateTime

Columns

ColumnName

DataType

TABLE_CATALOG

String

TABLE_SCHEMA

String

TABLE_NAME

String

COLUMN_NAME

String

COLUMN_GUID

Guid

COLUMN_PROPID

Int64

ORDINAL_POSITION

Int64

COLUMN_HASDEFAULT

Boolean

COLUMN_DEFAULT

String

COLUMN_FLAGS

Int64

IS_NULLABLE

Boolean

DATA_TYPE

Int32

TYPE_GUID

Guid

CHARACTER_MAXIMUM_LENGTH

Int64

CHARACTER_OCTET_LENGTH

Int64

NUMERIC_PRECISION

Int32

NUMERIC_SCALE

Int16

DATETIME_PRECISION

Int64

CHARACTER_SET_CATALOG

String

CHARACTER_SET_SCHEMA

String

CHARACTER_SET_NAME

String

COLLATION_CATALOG

String

COLLATION_SCHEMA

String

COLLATION_NAME

String

DOMAIN_CATALOG

String

DOMAIN_SCHEMA

String

DOMAIN_NAME

String

DESCRIPTION

String

COLUMN_LCID

Int32

COLUMN_COMPFLAGS

Int32

COLUMN_SORTID

Int32

COLUMN_TDSCOLLATION

Byte[]

IS_COMPUTED

Boolean

Procedures

ColumnName

DataType

PROCEDURE_CATALOG

String

PROCEDURE_SCHEMA

String

PROCEDURE_NAME

String

PROCEDURE_TYPE

Int16

PROCEDURE_DEFINITION

String

DESCRIPTION

String

DATE_CREATED

DateTime

DATE_MODIFIED

DateTime

ProcedureParameters

ColumnName

DataType

PROCEDURE_CATALOG

String

PROCEDURE_SCHEMA

String

PROCEDURE_NAME

String

PARAMETER_NAME

String

ORDINAL_POSITION

Int32

PARAMETER_TYPE

Int32

PARAMETER_HASDEFAULT

Boolean

PARAMETER_DEFAULT

String

IS_NULLABLE

Boolean

DATA_TYPE

Int32

CHARACTER_MAXIMUM_LENGTH

Int64

CHARACTER_OCTET_LENGTH

Int64

NUMERIC_PRECISION

Int32

NUMERIC_SCALE

Int16

DESCRIPTION

String

TYPE_NAME

String

LOCAL_TYPE_NAME

String

Catalog

ColumnName

DataType

CATALOG_NAME

String

DESCRIPTION

String

Indexes

ColumnName

DataType

TABLE_CATALOG

String

TABLE_SCHEMA

String

TABLE_NAME

String

INDEX_CATALOG

String

INDEX_SCHEMA

String

INDEX_NAME

String

PRIMARY_KEY

Boolean

UNIQUE

Boolean

CLUSTERED

Boolean

TYPE

Int32

FILL_FACTOR

Int32

INITIAL_SIZE

Int32

NULLS

Int32

SORT_BOOKMARKS

Boolean

AUTO_UPDATE

Boolean

NULL_COLLATION

Int32

ORDINAL_POSITION

Int64

COLUMN_NAME

String

COLUMN_GUID

Guid

COLUMN_PROPID

Int64

COLLATION

Int16

CARDINALITY

Decimal

PAGES

Int32

FILTER_CONDITION

String

INTEGRATED

Boolean

Microsoft Oracle OLE DB Provider

The Microsoft Oracle OLE DB Driver supports the following specific schema collections in addition to the common schema collections:

  • Tables

  • Columns

  • Procedures

  • ProcedureColumns

  • ProcedureParameters

  • Views

  • Indexes

Tables

ColumnName

DataType

TABLE_CATALOG

String

TABLE_SCHEMA

String

TABLE_NAME

String

TABLE_TYPE

String

TABLE_GUID

Guid

DESCRIPTION

String

TABLE_PROPID

Int64

DATE_CREATED

DateTime

DATE_MODIFIED

DateTime

Columns

ColumnName

DataType

TABLE_CATALOG

String

TABLE_SCHEMA

String

TABLE_NAME

String

COLUMN_NAME

String

COLUMN_GUID

Guid

COLUMN_PROPID

Int64

ORDINAL_POSITION

Int64

COLUMN_HASDEFAULT

Boolean

COLUMN_DEFAULT

String

COLUMN_FLAGS

Int64

IS_NULLABLE

Boolean

DATA_TYPE

Int32

TYPE_GUID

Guid

CHARACTER_MAXIMUM_LENGTH

Int64

CHARACTER_OCTET_LENGTH

Int64

NUMERIC_PRECISION

Int32

NUMERIC_SCALE

Int16

DATETIME_PRECISION

Int64

CHARACTER_SET_CATALOG

String

CHARACTER_SET_SCHEMA

String

CHARACTER_SET_NAME

String

COLLATION_CATALOG

String

COLLATION_SCHEMA

String

COLLATION_NAME

String

DOMAIN_CATALOG

String

DOMAIN_SCHEMA

String

DOMAIN_NAME

String

DESCRIPTION

String

Procedures

ColumnName

DataType

PROCEDURE_CATALOG

String

PROCEDURE_SCHEMA

String

PROCEDURE_NAME

String

PROCEDURE_TYPE

Int16

PROCEDURE_DEFINITION

String

DESCRIPTION

String

DATE_CREATED

DateTime

DATE_MODIFIED

DateTime

ProcedureColumns

ColumnName

DataType

PROCEDURE_CATALOG

String

PROCEDURE_SCHEMA

String

PROCEDURE_NAME

String

COLUMN_NAME

String

COLUMN_GUID

Guid

COLUMN_PROPID

Int64

ROWSET_NUMBER

Int64

ORDINAL_POSITION

Int64

IS_NULLABLE

Boolean

DATA_TYPE

Int32

TYPE_GUID

Guid

CHARACTER_MAXIMUM_LENGTH

Int64

CHARACTER_OCTET_LENGTH

Int64

NUMERIC_PRECISION

Int32

NUMERIC_SCALE

Int16

DESCRIPTION

String

OVERLOAD

Int16

Views

ColumnName

DataType

TABLE_CATALOG

String

TABLE_SCHEMA

String

TABLE_NAME

String

VIEW_DEFINITION

String

CHECK_OPTION

Boolean

IS_UPDATABLE

Boolean

DESCRIPTION

String

DATE_CREATED

DateTime

DATE_MODIFIED

DateTime

Indexes

ColumnName

DataType

TABLE_CATALOG

String

TABLE_SCHEMA

String

TABLE_NAME

String

INDEX_CATALOG

String

INDEX_SCHEMA

String

INDEX_NAME

String

PRIMARY_KEY

Boolean

UNIQUE

Boolean

CLUSTERED

Boolean

TYPE

Int32

FILL_FACTOR

Int32

INITIAL_SIZE

Int32

NULLS

Int32

SORT_BOOKMARKS

Boolean

AUTO_UPDATE

Boolean

NULL_COLLATION

Int32

ORDINAL_POSITION

Int64

COLUMN_NAME

String

COLUMN_GUID

Guid

COLUMN_PROPID

Int64

COLLATION

Int16

CARDINALITY

Decimal

PAGES

Int32

FILTER_CONDITION

String

INTEGRATED

Boolean

Microsoft Jet OLE DB Provider

The Microsoft Jet OLE DB Driver supports the following specific schema collections in addition to the common schema collections:

  • Tables

  • Columns

  • Procedures

  • Views

  • Indexes

Tables

ColumnName

DataType

TABLE_CATALOG

String

TABLE_SCHEMA

String

TABLE_NAME

String

TABLE_TYPE

String

TABLE_GUID

Guid

DESCRIPTION

String

TABLE_PROPID

Int64

DATE_CREATED

DateTime

DATE_MODIFIED

DateTime

Columns

ColumnName

DataType

TABLE_CATALOG

String

TABLE_SCHEMA

String

TABLE_NAME

String

COLUMN_NAME

String

COLUMN_GUID

Guid

COLUMN_PROPID

Int64

ORDINAL_POSITION

Int64

COLUMN_HASDEFAULT

Boolean

COLUMN_DEFAULT

String

COLUMN_FLAGS

Int64

IS_NULLABLE

Boolean

DATA_TYPE

Int32

TYPE_GUID

Guid

CHARACTER_MAXIMUM_LENGTH

Int64

CHARACTER_OCTET_LENGTH

Int64

NUMERIC_PRECISION

Int32

NUMERIC_SCALE

Int16

DATETIME_PRECISION

Int64

CHARACTER_SET_CATALOG

String

CHARACTER_SET_SCHEMA

String

CHARACTER_SET_NAME

String

COLLATION_CATALOG

String

COLLATION_SCHEMA

String

COLLATION_NAME

String

DOMAIN_CATALOG

String

DOMAIN_SCHEMA

String

DOMAIN_NAME

String

DESCRIPTION

String

Procedures

ColumnName

DataType

PROCEDURE_CATALOG

String

PROCEDURE_SCHEMA

String

PROCEDURE_NAME

String

PROCEDURE_TYPE

Int16

PROCEDURE_DEFINITION

String

DESCRIPTION

String

DATE_CREATED

DateTime

DATE_MODIFIED

DateTime

Views

ColumnName

DataType

TABLE_CATALOG

String

TABLE_SCHEMA

String

TABLE_NAME

String

VIEW_DEFINITION

String

CHECK_OPTION

Boolean

IS_UPDATABLE

Boolean

DESCRIPTION

String

DATE_CREATED

DateTime

DATE_MODIFIED

DateTime

Indexes

ColumnName

DataType

TABLE_CATALOG

String

TABLE_SCHEMA

String

TABLE_NAME

String

INDEX_CATALOG

String

INDEX_SCHEMA

String

INDEX_NAME

String

PRIMARY_KEY

Boolean

UNIQUE

Boolean

CLUSTERED

Boolean

TYPE

Int32

FILL_FACTOR

Int32

INITIAL_SIZE

Int32

NULLS

Int32

SORT_BOOKMARKS

Boolean

AUTO_UPDATE

Boolean

NULL_COLLATION

Int32

ORDINAL_POSITION

Int64

COLUMN_NAME

String

COLUMN_GUID

Guid

COLUMN_PROPID

Int64

COLLATION

Int16

CARDINALITY

Decimal

PAGES

Int32

FILTER_CONDITION

String

INTEGRATED

Boolean

See Also

Other Resources

ADO.NET Managed Providers and DataSet Developer Center