OLE DB Schema Collections
Article 09/15/2021
10 contributors
Feedback
In this article
Microsoft SQL Server OLE DB Provider
Microsoft Oracle OLE DB Provider
Microsoft Jet OLE DB Provider
See also
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
Expand table
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
Expand table
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
Expand table
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
Expand table
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
Expand table
ColumnName
DataType
CATALOG_NAME
String
DESCRIPTION
String
Expand table
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
Expand table
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
Expand table
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
Expand table
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
Expand table
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
Expand table
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
Expand table
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
Expand table
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
Expand table
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
Expand table
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
Expand table
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
Expand table
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