OLE DB Schema Collections

 

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

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

ColumnNameDataType
TABLE_CATALOGString
TABLE_SCHEMAString
TABLE_NAMEString
TABLE_TYPEString
TABLE_GUIDGuid
DESCRIPTIONString
TABLE_PROPIDInt64
DATE_CREATEDDateTime
DATE_MODIFIEDDateTime

Columns

ColumnNameDataType
TABLE_CATALOGString
TABLE_SCHEMAString
TABLE_NAMEString
COLUMN_NAMEString
COLUMN_GUIDGuid
COLUMN_PROPIDInt64
ORDINAL_POSITIONInt64
COLUMN_HASDEFAULTBoolean
COLUMN_DEFAULTString
COLUMN_FLAGSInt64
IS_NULLABLEBoolean
DATA_TYPEInt32
TYPE_GUIDGuid
CHARACTER_MAXIMUM_LENGTHInt64
CHARACTER_OCTET_LENGTHInt64
NUMERIC_PRECISIONInt32
NUMERIC_SCALEInt16
DATETIME_PRECISIONInt64
CHARACTER_SET_CATALOGString
CHARACTER_SET_SCHEMAString
CHARACTER_SET_NAMEString
COLLATION_CATALOGString
COLLATION_SCHEMAString
COLLATION_NAMEString
DOMAIN_CATALOGString
DOMAIN_SCHEMAString
DOMAIN_NAMEString
DESCRIPTIONString
COLUMN_LCIDInt32
COLUMN_COMPFLAGSInt32
COLUMN_SORTIDInt32
COLUMN_TDSCOLLATIONByte[]
IS_COMPUTEDBoolean

Procedures

ColumnNameDataType
PROCEDURE_CATALOGString
PROCEDURE_SCHEMAString
PROCEDURE_NAMEString
PROCEDURE_TYPEInt16
PROCEDURE_DEFINITIONString
DESCRIPTIONString
DATE_CREATEDDateTime
DATE_MODIFIEDDateTime

ProcedureParameters

ColumnNameDataType
PROCEDURE_CATALOGString
PROCEDURE_SCHEMAString
PROCEDURE_NAMEString
PARAMETER_NAMEString
ORDINAL_POSITIONInt32
PARAMETER_TYPEInt32
PARAMETER_HASDEFAULTBoolean
PARAMETER_DEFAULTString
IS_NULLABLEBoolean
DATA_TYPEInt32
CHARACTER_MAXIMUM_LENGTHInt64
CHARACTER_OCTET_LENGTHInt64
NUMERIC_PRECISIONInt32
NUMERIC_SCALEInt16
DESCRIPTIONString
TYPE_NAMEString
LOCAL_TYPE_NAMEString

Catalog

ColumnNameDataType
CATALOG_NAMEString
DESCRIPTIONString

Indexes

ColumnNameDataType
TABLE_CATALOGString
TABLE_SCHEMAString
TABLE_NAMEString
INDEX_CATALOGString
INDEX_SCHEMAString
INDEX_NAMEString
PRIMARY_KEYBoolean
UNIQUEBoolean
CLUSTEREDBoolean
TYPEInt32
FILL_FACTORInt32
INITIAL_SIZEInt32
NULLSInt32
SORT_BOOKMARKSBoolean
AUTO_UPDATEBoolean
NULL_COLLATIONInt32
ORDINAL_POSITIONInt64
COLUMN_NAMEString
COLUMN_GUIDGuid
COLUMN_PROPIDInt64
COLLATIONInt16
CARDINALITYDecimal
PAGESInt32
FILTER_CONDITIONString
INTEGRATEDBoolean

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

ColumnNameDataType
TABLE_CATALOGString
TABLE_SCHEMAString
TABLE_NAMEString
TABLE_TYPEString
TABLE_GUIDGuid
DESCRIPTIONString
TABLE_PROPIDInt64
DATE_CREATEDDateTime
DATE_MODIFIEDDateTime

Columns

ColumnNameDataType
TABLE_CATALOGString
TABLE_SCHEMAString
TABLE_NAMEString
COLUMN_NAMEString
COLUMN_GUIDGuid
COLUMN_PROPIDInt64
ORDINAL_POSITIONInt64
COLUMN_HASDEFAULTBoolean
COLUMN_DEFAULTString
COLUMN_FLAGSInt64
IS_NULLABLEBoolean
DATA_TYPEInt32
TYPE_GUIDGuid
CHARACTER_MAXIMUM_LENGTHInt64
CHARACTER_OCTET_LENGTHInt64
NUMERIC_PRECISIONInt32
NUMERIC_SCALEInt16
DATETIME_PRECISIONInt64
CHARACTER_SET_CATALOGString
CHARACTER_SET_SCHEMAString
CHARACTER_SET_NAMEString
COLLATION_CATALOGString
COLLATION_SCHEMAString
COLLATION_NAMEString
DOMAIN_CATALOGString
DOMAIN_SCHEMAString
DOMAIN_NAMEString
DESCRIPTIONString

Procedures

ColumnNameDataType
PROCEDURE_CATALOGString
PROCEDURE_SCHEMAString
PROCEDURE_NAMEString
PROCEDURE_TYPEInt16
PROCEDURE_DEFINITIONString
DESCRIPTIONString
DATE_CREATEDDateTime
DATE_MODIFIEDDateTime

ProcedureColumns

ColumnNameDataType
PROCEDURE_CATALOGString
PROCEDURE_SCHEMAString
PROCEDURE_NAMEString
COLUMN_NAMEString
COLUMN_GUIDGuid
COLUMN_PROPIDInt64
ROWSET_NUMBERInt64
ORDINAL_POSITIONInt64
IS_NULLABLEBoolean
DATA_TYPEInt32
TYPE_GUIDGuid
CHARACTER_MAXIMUM_LENGTHInt64
CHARACTER_OCTET_LENGTHInt64
NUMERIC_PRECISIONInt32
NUMERIC_SCALEInt16
DESCRIPTIONString
OVERLOADInt16

Views

ColumnNameDataType
TABLE_CATALOGString
TABLE_SCHEMAString
TABLE_NAMEString
VIEW_DEFINITIONString
CHECK_OPTIONBoolean
IS_UPDATABLEBoolean
DESCRIPTIONString
DATE_CREATEDDateTime
DATE_MODIFIEDDateTime

Indexes

ColumnNameDataType
TABLE_CATALOGString
TABLE_SCHEMAString
TABLE_NAMEString
INDEX_CATALOGString
INDEX_SCHEMAString
INDEX_NAMEString
PRIMARY_KEYBoolean
UNIQUEBoolean
CLUSTEREDBoolean
TYPEInt32
FILL_FACTORInt32
INITIAL_SIZEInt32
NULLSInt32
SORT_BOOKMARKSBoolean
AUTO_UPDATEBoolean
NULL_COLLATIONInt32
ORDINAL_POSITIONInt64
COLUMN_NAMEString
COLUMN_GUIDGuid
COLUMN_PROPIDInt64
COLLATIONInt16
CARDINALITYDecimal
PAGESInt32
FILTER_CONDITIONString
INTEGRATEDBoolean

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

ColumnNameDataType
TABLE_CATALOGString
TABLE_SCHEMAString
TABLE_NAMEString
TABLE_TYPEString
TABLE_GUIDGuid
DESCRIPTIONString
TABLE_PROPIDInt64
DATE_CREATEDDateTime
DATE_MODIFIEDDateTime

Columns

ColumnNameDataType
TABLE_CATALOGString
TABLE_SCHEMAString
TABLE_NAMEString
COLUMN_NAMEString
COLUMN_GUIDGuid
COLUMN_PROPIDInt64
ORDINAL_POSITIONInt64
COLUMN_HASDEFAULTBoolean
COLUMN_DEFAULTString
COLUMN_FLAGSInt64
IS_NULLABLEBoolean
DATA_TYPEInt32
TYPE_GUIDGuid
CHARACTER_MAXIMUM_LENGTHInt64
CHARACTER_OCTET_LENGTHInt64
NUMERIC_PRECISIONInt32
NUMERIC_SCALEInt16
DATETIME_PRECISIONInt64
CHARACTER_SET_CATALOGString
CHARACTER_SET_SCHEMAString
CHARACTER_SET_NAMEString
COLLATION_CATALOGString
COLLATION_SCHEMAString
COLLATION_NAMEString
DOMAIN_CATALOGString
DOMAIN_SCHEMAString
DOMAIN_NAMEString
DESCRIPTIONString

Procedures

ColumnNameDataType
PROCEDURE_CATALOGString
PROCEDURE_SCHEMAString
PROCEDURE_NAMEString
PROCEDURE_TYPEInt16
PROCEDURE_DEFINITIONString
DESCRIPTIONString
DATE_CREATEDDateTime
DATE_MODIFIEDDateTime

Views

ColumnNameDataType
TABLE_CATALOGString
TABLE_SCHEMAString
TABLE_NAMEString
VIEW_DEFINITIONString
CHECK_OPTIONBoolean
IS_UPDATABLEBoolean
DESCRIPTIONString
DATE_CREATEDDateTime
DATE_MODIFIEDDateTime

Indexes

ColumnNameDataType
TABLE_CATALOGString
TABLE_SCHEMAString
TABLE_NAMEString
INDEX_CATALOGString
INDEX_SCHEMAString
INDEX_NAMEString
PRIMARY_KEYBoolean
UNIQUEBoolean
CLUSTEREDBoolean
TYPEInt32
FILL_FACTORInt32
INITIAL_SIZEInt32
NULLSInt32
SORT_BOOKMARKSBoolean
AUTO_UPDATEBoolean
NULL_COLLATIONInt32
ORDINAL_POSITIONInt64
COLUMN_NAMEString
COLUMN_GUIDGuid
COLUMN_PROPIDInt64
COLLATIONInt16
CARDINALITYDecimal
PAGESInt32
FILTER_CONDITIONString
INTEGRATEDBoolean

ADO.NET Managed Providers and DataSet Developer Center

Show: