ODBC 結構描述集合
本節將討論 Microsoft SQL Server、Oracle 和 Microsoft Jet 之 ODBC 驅動程式的結構描述集合支援。
Microsoft SQL Server ODBC 驅動程式
除了一般結構描述集合之外，Microsoft SQL Server ODBC 驅動程式還支援下列特定的結構描述集合：
資料表
索引數
資料行
程序
ProcedureColumns
ProcedureParameters
檢視
資料表和檢視表
| ColumnName | DataType |
|---|---|
| TABLE_CAT | String |
| TABLE_SCHEM | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| REMARKS | String |
索引
| 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 |
| CARDINALITY | Int32 |
| PAGES | Int32 |
| FILTER_CONDITION | String |
| SS_TYPE_SCHEMA | String |
| SS_DATA_TYPE | Byte |
資料行
| 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 |
程序
| 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 驅動程式
除了一般結構描述集合之外，Microsoft SQL Server Oracle ODBC 驅動程式還支援下列特定的結構描述集合：
資料表
資料行
程序
ProcedureColumns
ProcedureParameters
檢視
索引數
資料表和檢視表
| ColumnName | DataType |
|---|---|
| TABLE_QUALIFIER | String |
| TABLE_OWNER | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| REMARKS | String |
資料行
| 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 |
程序
| 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 驅動程式
除了通用結構描述集合之外，Microsoft Jet ODBC 驅動程式還支援下列特定的結構描述集合：
資料表
索引數
資料行
程序
ProcedureColumns
ProcedureParameters
檢視
資料表和檢視表
| ColumnName | DataType |
|---|---|
| TABLE_QUALIFIER | String |
| TABLE_OWNER | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| REMARKS | String |
資料行
| 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 |
程序
| 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 |
另請參閱
- ADO.NET 概觀 \(部分機器翻譯\)