OLE DB Schema Collections

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