ODBC Schema Collections (ADO.NET)

  • Article

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

Other Resources

ADO.NET Managed Providers and DataSet Developer Center