Freigeben über

ODBC-Schemaauflistungen (ADO.NET)

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:

  • Tabellen

  • Indexes

  • Columns

  • Prozeduren

  • ProcedureColumns

  • ProcedureParameters

  • Ansichten

Tabellen und Ansichten

Spaltenname

Datentyp

TABLE_CAT

String

TABLE_SCHEM

String

TABLE_NAME

String

TABLE_TYPE

String

REMARKS

String

Indizes

Spaltenname

Datentyp

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

Spalten

Spaltenname

Datentyp

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

Prozeduren

Spaltenname

Datentyp

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

Spaltenname

Datentyp

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

Spaltenname

Datentyp

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

  • Prozeduren

  • ProcedureColumns

  • ProcedureParameters

  • Ansichten

  • Indizes

Tabellen und Ansichten

Spaltenname

Datentyp

TABLE_QUALIFIER

String

TABLE_OWNER

String

TABLE_NAME

String

TABLE_TYPE

String

REMARKS

String

Spalten

Spaltenname

Datentyp

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

Prozeduren

Spaltenname

Datentyp

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

Spaltenname

Datentyp

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:

  • Tabellen

  • Indexes

  • Columns

  • Prozeduren

  • ProcedureColumns

  • ProcedureParameters

  • Ansichten

Tabellen und Ansichten

Spaltenname

Datentyp

TABLE_QUALIFIER

String

TABLE_OWNER

String

TABLE_NAME

String

TABLE_TYPE

String

REMARKS

String

Spalten

Spaltenname

Datentyp

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

Prozeduren

Spaltenname

Datentyp

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

Spaltenname

Datentyp

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

Spaltenname

Datentyp

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
  • Last updated on