Kolekcje schematów ODBC
W tej sekcji omówiono obsługę zbierania schematów dla sterowników ODBC dla programów Microsoft SQL Server, Oracle i Microsoft Jet.
Sterownik ODBC programu Microsoft SQL Server
Sterownik ODBC programu Microsoft SQL Server obsługuje następujące kolekcje schematów oprócz typowych kolekcji schematów:
Tabele
Indeksy
Kolumny
z konkretnym obiektem
Kolumny procedury
Parametry procedury
Widoki
Tabele i widoki
| ColumnName | DataType |
|---|---|
| TABLE_CAT | String |
| TABLE_SCHEM | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| UWAGI | String |
Indeksy
| ColumnName | DataType |
|---|---|
| TABLE_CAT | String |
| TABLE_SCHEM | String |
| TABLE_NAME | String |
| NON_UNIQUE | Int16 |
| INDEX_QUALIFIER | String |
| INDEX_NAME | String |
| TYP | Int16 |
| ORDINAL_POSITION | Int16 |
| COLUMN_NAME | String |
| ASC_OR_DESC | String |
| KARDYNALNOŚĆ | Int32 |
| STRON | Int32 |
| FILTER_CONDITION | String |
| SS_TYPE_SCHEMA | String |
| SS_DATA_TYPE | Byte |
Kolumny
| 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 |
| UWAGI | 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 |
z konkretnym obiektem
| ColumnName | DataType |
|---|---|
| PROCEDURE_CAT | String |
| PROCEDURE_SCHEM | String |
| PROCEDURE_NAME | String |
| NUM_INPUT_PARAMS | Int32 |
| NUM_OUTPUT_PARAMS | Int32 |
| NUM_RESULT_SETS | Int32 |
| UWAGI | String |
| PROCEDURE_TYPE | Int16 |
Kolumny procedury
| 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 |
| UWAGI | 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 |
Parametry procedury
| 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 |
| UWAGI | 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 |
Sterownik Microsoft Oracle ODBC
Sterownik Microsoft SQL Server Oracle ODBC obsługuje następujące kolekcje schematów oprócz typowych kolekcji schematów:
Tabele
Kolumny
z konkretnym obiektem
Kolumny procedury
Parametry procedury
Widoki
Indeksy
Tabele i widoki
| ColumnName | DataType |
|---|---|
| TABLE_QUALIFIER | String |
| TABLE_OWNER | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| UWAGI | String |
Kolumny
| ColumnName | DataType |
|---|---|
| TABLE_QUALIFIER | String |
| TABLE_OWNER | String |
| TABLE_NAME | String |
| COLUMN_NAME | String |
| DATA_TYPE | Int16 |
| TYPE_NAME | String |
| PRECYZJI | Int32 |
| LENGTH | Int32 |
| SKALA | Int16 |
| PODSTAWA | Int16 |
| NULLABLE | Int16 |
| UWAGI | String |
| ORDINAL_POSITION | Int32 |
z konkretnym obiektem
| ColumnName | DataType |
|---|---|
| PROCEDURE_QUALIFIER | String |
| PROCEDURE_OWNER | String |
| PROCEDURE_NAME | String |
| NUM_INPUT_PARAMS | Int16 |
| NUM_OUTPUT_PARAMS | Int16 |
| NUM_RESULT_SETS | Int16 |
| UWAGI | String |
| PROCEDURE_TYPE | Int16 |
Kolumny procedury
| ColumnName | DataType |
|---|---|
| PROCEDURE_QUALIFIER | String |
| PROCEDURE_OWNER | String |
| PROCEDURE_NAME | String |
| COLUMN_NAME | String |
| COLUMN_TYPE | Int16 |
| DATA_TYPE | Int16 |
| TYPE_NAME | String |
| PRECYZJI | Int32 |
| LENGTH | Int32 |
| SKALA | Int16 |
| PODSTAWA | Int16 |
| NULLABLE | Int16 |
| UWAGI | String |
| PRZECIĄŻENIE | Int32 |
| ORDINAL_POSITION | Int32 |
Sterownik Microsoft Jet ODBC
Sterownik Microsoft Jet ODBC obsługuje następujące kolekcje schematów oprócz typowych kolekcji schematów:
Tabele
Indeksy
Kolumny
z konkretnym obiektem
Kolumny procedury
Parametry procedury
Widoki
Tabele i widoki
| ColumnName | DataType |
|---|---|
| TABLE_QUALIFIER | String |
| TABLE_OWNER | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| UWAGI | String |
Kolumny
| ColumnName | DataType |
|---|---|
| TABLE_QUALIFIER | String |
| TABLE_OWNER | String |
| TABLE_NAME | String |
| COLUMN_NAME | String |
| DATA_TYPE | Int16 |
| TYPE_NAME | String |
| PRECYZJI | Int32 |
| LENGTH | Int32 |
| SKALA | Int16 |
| PODSTAWA | Int16 |
| NULLABLE | Int16 |
| UWAGI | String |
| ORDINAL_POSITION | Int32 |
z konkretnym obiektem
| ColumnName | DataType |
|---|---|
| PROCEDURE_QUALIFIER | String |
| PROCEDURE_OWNER | String |
| PROCEDURE_NAME | String |
| NUM_INPUT_PARAMS | Int16 |
| NUM_OUTPUT_PARAMS | Int16 |
| NUM_RESULT_SETS | Int16 |
| UWAGI | String |
| PROCEDURE_TYPE | Int16 |
Kolumny procedury
| ColumnName | DataType |
|---|---|
| PROCEDURE_QUALIFIER | String |
| PROCEDURE_OWNER | String |
| PROCEDURE_NAME | String |
| COLUMN_NAME | String |
| COLUMN_TYPE | Int16 |
| DATA_TYPE | Int16 |
| TYPE_NAME | String |
| PRECYZJI | Int32 |
| LENGTH | Int32 |
| SKALA | Int16 |
| PODSTAWA | Int16 |
| NULLABLE | Int16 |
| UWAGI | String |
| PRZECIĄŻENIE | Int32 |
| ORDINAL_POSITION | Int32 |
Parametry procedury
| 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 |
| UWAGI | String |
| COLUMN_DEF | String |
| SQL_DATA_TYPE | Int16 |
| SQL_DATETIME_SUB | Int16 |
| CHAR_OCTET_LENGTH | Int32 |
| ORDINAL_POSITION | Int32 |
| IS_NULLABLE | String |