ODBC Schema Collections

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

Microsoft SQL Server ODBC Driver

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

ColumnName DataType
TABLE_CAT String
TABLE_SCHEM String
TABLE_NAME String
TABLE_TYPE String
REMARKS String

Indexes

ColumnName DataType
TABLE_CAT String
TABLE_SCHEM String
TABLE_NAME String
NON_UNIQUE Int16
INDEX_QUALIFIER String
INDEX_NAME String
TYPE Int16
ORDINAL_POSITION Int16
COLUMN_NAME String
ASC_OR_DESC String
CARDINATLITY Int32
PAGES Int32
FILTER_CONDITION String
SS_TYPE_SCHEMA String
SS_DATA_TYPE Byte

Columns

ColumnName DataType
TABLE_CAT String
TABLE_SCHEM String
TABLE_NAME String
COLUMN_NAME String
DATA_TYPE Int16
TYPE_NAME String
COLUMN_SIZE Int32
BUFFER_LENGTH Int32
DECIMAL_DIGITS Int16
NUM_PREC_RADIX Int16
NULLABLE Int16
REMARKS String
COLUMN_DEF String
SQL_DATA_TYPE Int16
SQL_DATETIME_SUB Int16
CHAR_OCTET_LENGTH Int32
ORDINAL_POSITION Int32
IS_NULLABLE String
SS_TYPE_CATALOG String
SS_TYPE_SCHEMA String
SS_DATA_TYPE Byte

Procedures

ColumnName DataType
PROCEDURE_CAT String
PROCEDURE_SCHEM String
PROCEDURE_NAME String
NUM_INPUT_PARAMS Int32
NUM_OUTPUT_PARAMS Int32
NUM_RESULT_SETS Int32
REMARKS String
PROCEDURE_TYPE Int16

ProcedureColumns

ColumnName DataType
PROCEDURE_CAT String
PROCEDURE_SCHEM String
PROCEDURE_NAME String
COLUMN_NAME String
COLUMN_TYPE Int16
DATA_TYPE Int16
TYPE_NAME String
COLUMN_SIZE Int32
BUFFER_LENGTH Int32
DECIMAL_DIGITS Int16
NUM_PREC_RADIX Int16
NULLABLE Int16
REMARKS String
COLUMN_DEF String
SQL_DATA_TYPE Int16
SQL_DATETIME_SUB Int16
CHAR_OCTET_LENGTH Int32
ORDINAL_POSITION Int32
IS_NULLABLE String
SS_TYPE_CATALOG String
SS_TYPE_SCHEMA String
SS_DATA_TYPE Byte

ProcedureParameters

ColumnName DataType
PROCEDURE_CAT String
PROCEDURE_SCHEM String
PROCEDURE_NAME String
COLUMN_NAME String
COLUMN_TYPE Int16
DATA_TYPE Int16
TYPE_NAME String
COLUMN_SIZE Int32
BUFFER_LENGTH Int32
DECIMAL_DIGITS Int16
NUM_PREC_RADIX Int16
NULLABLE Int16
REMARKS String
COLUMN_DEF String
SQL_DATA_TYPE Int16
SQL_DATETIME_SUB Int16
CHAR_OCTET_LENGTH Int32
ORDINAL_POSITION Int32
IS_NULLABLE String
SS_TYPE_CATALOG String
SS_TYPE_SCHEMA String
SS_DATA_TYPE Byte

Microsoft Oracle ODBC Driver

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

ColumnName DataType
TABLE_QUALIFIER String
TABLE_OWNER String
TABLE_NAME String
TABLE_TYPE String
REMARKS String

Columns

ColumnName DataType
TABLE_QUALIFIER String
TABLE_OWNER String
TABLE_NAME String
COLUMN_NAME String
DATA_TYPE Int16
TYPE_NAME String
PRECISION Int32
LENGTH Int32
SCALE Int16
RADIX Int16
NULLABLE Int16
REMARKS String
ORDINAL_POSITION Int32

Procedures

ColumnName DataType
PROCEDURE_QUALIFIER String
PROCEDURE_OWNER String
PROCEDURE_NAME String
NUM_INPUT_PARAMS Int16
NUM_OUTPUT_PARAMS Int16
NUM_RESULT_SETS Int16
REMARKS String
PROCEDURE_TYPE Int16

ProcedureColumns

ColumnName DataType
PROCEDURE_QUALIFIER String
PROCEDURE_OWNER String
PROCEDURE_NAME String
COLUMN_NAME String
COLUMN_TYPE Int16
DATA_TYPE Int16
TYPE_NAME String
PRECISION Int32
LENGTH Int32
SCALE Int16
RADIX Int16
NULLABLE Int16
REMARKS String
OVERLOAD Int32
ORDINAL_POSITION Int32

Microsoft Jet ODBC Driver

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

ColumnName DataType
TABLE_QUALIFIER String
TABLE_OWNER String
TABLE_NAME String
TABLE_TYPE String
REMARKS String

Columns

ColumnName DataType
TABLE_QUALIFIER String
TABLE_OWNER String
TABLE_NAME String
COLUMN_NAME String
DATA_TYPE Int16
TYPE_NAME String
PRECISION Int32
LENGTH Int32
SCALE Int16
RADIX Int16
NULLABLE Int16
REMARKS String
ORDINAL_POSITION Int32

Procedures

ColumnName DataType
PROCEDURE_QUALIFIER String
PROCEDURE_OWNER String
PROCEDURE_NAME String
NUM_INPUT_PARAMS Int16
NUM_OUTPUT_PARAMS Int16
NUM_RESULT_SETS Int16
REMARKS String
PROCEDURE_TYPE Int16

ProcedureColumns

ColumnName DataType
PROCEDURE_QUALIFIER String
PROCEDURE_OWNER String
PROCEDURE_NAME String
COLUMN_NAME String
COLUMN_TYPE Int16
DATA_TYPE Int16
TYPE_NAME String
PRECISION Int32
LENGTH Int32
SCALE Int16
RADIX Int16
NULLABLE Int16
REMARKS String
OVERLOAD Int32
ORDINAL_POSITION Int32

ProcedureParameters

ColumnName DataType
PROCEDURE_CAT String
PROCEDURE_SCHEM String
PROCEDURE_NAME String
COLUMN_NAME String
COLUMN_TYPE Int16
DATA_TYPE Int16
TYPE_NAME String
COLUMN_SIZE Int32
BUFFER_LENGTH Int32
DECIMAL_DIGITS Int16
NUM_PREC_RADIX Int16
NULLABLE Int16
REMARKS String
COLUMN_DEF String
SQL_DATA_TYPE Int16
SQL_DATETIME_SUB Int16
CHAR_OCTET_LENGTH Int32
ORDINAL_POSITION Int32
IS_NULLABLE String

See Also

ADO.NET Managed Providers and DataSet Developer Center