ODBC スキーマ コレクション (ADO.NET)
更新 : November 2007
ここでは、Microsoft SQL Server、Oracle、および Microsoft Jet 用の各 ODBC ドライバでのスキーマ コレクションのサポートについて説明します。
Microsoft SQL Server ODBC Driver
Microsoft SQL Server ODBC Driver は、共通のスキーマ コレクションに加えて次のスキーマ コレクションをサポートしています。
Tables
Indexes
Columns
Procedures
ProcedureColumns
ProcedureParameters
Views
Tables と 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
Microsoft SQL Server Oracle ODBC Driver は、共通のスキーマ コレクションに加えて次のスキーマ コレクションをサポートしています。
Tables
Columns
Procedures
ProcedureColumns
ProcedureParameters
Views
Indexes
Tables と 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
Microsoft Jet ODBC Driver は、共通のスキーマ コレクションに加えて次のスキーマ コレクションをサポートしています。
Tables
Indexes
Columns
Procedures
ProcedureColumns
ProcedureParameters
Views
Tables と 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 |