Koleksi Skema ODBC
Bagian ini membahas dukungan kumpulan skema untuk driver ODBC untuk Microsoft SQL Server, Oracle, dan Microsoft Jet.
Driver ODBC Microsoft SQL Server
Driver ODBC Microsoft SQL Server mendukung kumpulan skema khusus berikut ini selain kumpulan skema umum:
Tabel
Indeks
Kolom
Prosedur
ProcedureColumns
ProcedureParameters
Tampilan
Tabel dan Tampilan
| ColumnName | DataType |
|---|---|
| TABLE_CAT | String |
| TABLE_SCHEM | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| REMARKS | String |
Indeks
| 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 |
Kolom
| 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 |
Prosedur
| 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
Driver ODBC Microsoft SQL Server Oracle mendukung kumpulan skema khusus berikut ini selain kumpulan skema umum:
Tabel
Kolom
Prosedur
ProcedureColumns
ProcedureParameters
Tampilan
Indeks
Tabel dan Tampilan
| ColumnName | DataType |
|---|---|
| TABLE_QUALIFIER | String |
| TABLE_OWNER | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| REMARKS | String |
Kolom
| ColumnName | DataType |
|---|---|
| TABLE_QUALIFIER | String |
| TABLE_OWNER | String |
| TABLE_NAME | String |
| COLUMN_NAME | String |
| DATA_TYPE | Int16 |
| TYPE_NAME | String |
| PRESISI | Int32 |
| LENGTH | Int32 |
| SKALA | Int16 |
| RADIX | Int16 |
| NULLABLE | Int16 |
| REMARKS | String |
| ORDINAL_POSITION | Int32 |
Prosedur
| 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 |
| PRESISI | Int32 |
| LENGTH | Int32 |
| SKALA | Int16 |
| RADIX | Int16 |
| NULLABLE | Int16 |
| REMARKS | String |
| OVERLOAD | Int32 |
| ORDINAL_POSITION | Int32 |
Microsoft Jet ODBC Driver
Microsoft Jet ODBC Driver mendukung kumpulan skema khusus berikut ini selain kumpulan skema umum:
Tabel
Indeks
Kolom
Prosedur
ProcedureColumns
ProcedureParameters
Tampilan
Tabel dan Tampilan
| ColumnName | DataType |
|---|---|
| TABLE_QUALIFIER | String |
| TABLE_OWNER | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| REMARKS | String |
Kolom
| ColumnName | DataType |
|---|---|
| TABLE_QUALIFIER | String |
| TABLE_OWNER | String |
| TABLE_NAME | String |
| COLUMN_NAME | String |
| DATA_TYPE | Int16 |
| TYPE_NAME | String |
| PRESISI | Int32 |
| LENGTH | Int32 |
| SKALA | Int16 |
| RADIX | Int16 |
| NULLABLE | Int16 |
| REMARKS | String |
| ORDINAL_POSITION | Int32 |
Prosedur
| 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 |
| PRESISI | Int32 |
| LENGTH | Int32 |
| SKALA | 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 |