ODBC-Schemaauflistungen (ADO.NET)

  • Artikel

Aktualisiert: November 2007

In diesem Abschnitt wird die Unterstützung von Schemaauflistungen für die ODBC-Treiber für Microsoft SQL Server, Oracle und Microsoft Jet diskutiert.

Microsoft SQL Server-ODBC-Treiber

Der Microsoft SQL Server-ODBC-Treiber unterstützt neben den allgemeinen Schemaauflistungen auch die folgenden spezifischen Schemaauflistungen:

  • 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-Treiber

Der Microsoft SQL Server Oracle ODBC-Treiber unterstützt neben den allgemeinen Schemaauflistungen auch die folgenden spezifischen Schemaauflistungen:

  • 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-Treiber

Der Microsoft Jet ODBC-Treiber unterstützt neben den allgemeinen Schemaauflistungen auch die folgenden spezifischen Schemaauflistungen:

  • 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