ODBC Schema Collections

 

This section discusses schema collection support for the ODBC drivers for Microsoft SQL Server, Oracle, and Microsoft Jet.

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

  • Tables

  • Indexes

  • Columns

  • Procedures

  • ProcedureColumns

  • ProcedureParameters

  • Views

Tables and Views

ColumnNameDataType
TABLE_CATString
TABLE_SCHEMString
TABLE_NAMEString
TABLE_TYPEString
REMARKSString

Indexes

ColumnNameDataType
TABLE_CATString
TABLE_SCHEMString
TABLE_NAMEString
NON_UNIQUEInt16
INDEX_QUALIFIERString
INDEX_NAMEString
TYPEInt16
ORDINAL_POSITIONInt16
COLUMN_NAMEString
ASC_OR_DESCString
CARDINATLITYInt32
PAGESInt32
FILTER_CONDITIONString
SS_TYPE_SCHEMAString
SS_DATA_TYPEByte

Columns

ColumnNameDataType
TABLE_CATString
TABLE_SCHEMString
TABLE_NAMEString
COLUMN_NAMEString
DATA_TYPEInt16
TYPE_NAMEString
COLUMN_SIZEInt32
BUFFER_LENGTHInt32
DECIMAL_DIGITSInt16
NUM_PREC_RADIXInt16
NULLABLEInt16
REMARKSString
COLUMN_DEFString
SQL_DATA_TYPEInt16
SQL_DATETIME_SUBInt16
CHAR_OCTET_LENGTHInt32
ORDINAL_POSITIONInt32
IS_NULLABLEString
SS_TYPE_CATALOGString
SS_TYPE_SCHEMAString
SS_DATA_TYPEByte

Procedures

ColumnNameDataType
PROCEDURE_CATString
PROCEDURE_SCHEMString
PROCEDURE_NAMEString
NUM_INPUT_PARAMSInt32
NUM_OUTPUT_PARAMSInt32
NUM_RESULT_SETSInt32
REMARKSString
PROCEDURE_TYPEInt16

ProcedureColumns

ColumnNameDataType
PROCEDURE_CATString
PROCEDURE_SCHEMString
PROCEDURE_NAMEString
COLUMN_NAMEString
COLUMN_TYPEInt16
DATA_TYPEInt16
TYPE_NAMEString
COLUMN_SIZEInt32
BUFFER_LENGTHInt32
DECIMAL_DIGITSInt16
NUM_PREC_RADIXInt16
NULLABLEInt16
REMARKSString
COLUMN_DEFString
SQL_DATA_TYPEInt16
SQL_DATETIME_SUBInt16
CHAR_OCTET_LENGTHInt32
ORDINAL_POSITIONInt32
IS_NULLABLEString
SS_TYPE_CATALOGString
SS_TYPE_SCHEMAString
SS_DATA_TYPEByte

ProcedureParameters

ColumnNameDataType
PROCEDURE_CATString
PROCEDURE_SCHEMString
PROCEDURE_NAMEString
COLUMN_NAMEString
COLUMN_TYPEInt16
DATA_TYPEInt16
TYPE_NAMEString
COLUMN_SIZEInt32
BUFFER_LENGTHInt32
DECIMAL_DIGITSInt16
NUM_PREC_RADIXInt16
NULLABLEInt16
REMARKSString
COLUMN_DEFString
SQL_DATA_TYPEInt16
SQL_DATETIME_SUBInt16
CHAR_OCTET_LENGTHInt32
ORDINAL_POSITIONInt32
IS_NULLABLEString
SS_TYPE_CATALOGString
SS_TYPE_SCHEMAString
SS_DATA_TYPEByte

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

  • Tables

  • Columns

  • Procedures

  • ProcedureColumns

  • ProcedureParameters

  • Views

  • Indexes

Tables and Views

ColumnNameDataType
TABLE_QUALIFIERString
TABLE_OWNERString
TABLE_NAMEString
TABLE_TYPEString
REMARKSString

Columns

ColumnNameDataType
TABLE_QUALIFIERString
TABLE_OWNERString
TABLE_NAMEString
COLUMN_NAMEString
DATA_TYPEInt16
TYPE_NAMEString
PRECISIONInt32
LENGTHInt32
SCALEInt16
RADIXInt16
NULLABLEInt16
REMARKSString
ORDINAL_POSITIONInt32

Procedures

ColumnNameDataType
PROCEDURE_QUALIFIERString
PROCEDURE_OWNERString
PROCEDURE_NAMEString
NUM_INPUT_PARAMSInt16
NUM_OUTPUT_PARAMSInt16
NUM_RESULT_SETSInt16
REMARKSString
PROCEDURE_TYPEInt16

ProcedureColumns

ColumnNameDataType
PROCEDURE_QUALIFIERString
PROCEDURE_OWNERString
PROCEDURE_NAMEString
COLUMN_NAMEString
COLUMN_TYPEInt16
DATA_TYPEInt16
TYPE_NAMEString
PRECISIONInt32
LENGTHInt32
SCALEInt16
RADIXInt16
NULLABLEInt16
REMARKSString
OVERLOADInt32
ORDINAL_POSITIONInt32

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

  • Tables

  • Indexes

  • Columns

  • Procedures

  • ProcedureColumns

  • ProcedureParameters

  • Views

Tables and Views

ColumnNameDataType
TABLE_QUALIFIERString
TABLE_OWNERString
TABLE_NAMEString
TABLE_TYPEString
REMARKSString

Columns

ColumnNameDataType
TABLE_QUALIFIERString
TABLE_OWNERString
TABLE_NAMEString
COLUMN_NAMEString
DATA_TYPEInt16
TYPE_NAMEString
PRECISIONInt32
LENGTHInt32
SCALEInt16
RADIXInt16
NULLABLEInt16
REMARKSString
ORDINAL_POSITIONInt32

Procedures

ColumnNameDataType
PROCEDURE_QUALIFIERString
PROCEDURE_OWNERString
PROCEDURE_NAMEString
NUM_INPUT_PARAMSInt16
NUM_OUTPUT_PARAMSInt16
NUM_RESULT_SETSInt16
REMARKSString
PROCEDURE_TYPEInt16

ProcedureColumns

ColumnNameDataType
PROCEDURE_QUALIFIERString
PROCEDURE_OWNERString
PROCEDURE_NAMEString
COLUMN_NAMEString
COLUMN_TYPEInt16
DATA_TYPEInt16
TYPE_NAMEString
PRECISIONInt32
LENGTHInt32
SCALEInt16
RADIXInt16
NULLABLEInt16
REMARKSString
OVERLOADInt32
ORDINAL_POSITIONInt32

ProcedureParameters

ColumnNameDataType
PROCEDURE_CATString
PROCEDURE_SCHEMString
PROCEDURE_NAMEString
COLUMN_NAMEString
COLUMN_TYPEInt16
DATA_TYPEInt16
TYPE_NAMEString
COLUMN_SIZEInt32
BUFFER_LENGTHInt32
DECIMAL_DIGITSInt16
NUM_PREC_RADIXInt16
NULLABLEInt16
REMARKSString
COLUMN_DEFString
SQL_DATA_TYPEInt16
SQL_DATETIME_SUBInt16
CHAR_OCTET_LENGTHInt32
ORDINAL_POSITIONInt32
IS_NULLABLEString

ADO.NET Managed Providers and DataSet Developer Center

Show: