Kolekcje schematów OLE DB
W tej sekcji omówiono obsługę zbierania schematów dla dostawców OLE DB dla programów Microsoft SQL Server, Oracle i Microsoft Jet.
Dostawca OLE DB programu Microsoft SQL Server
Sterownik OLE DB programu Microsoft SQL Server obsługuje następujące kolekcje schematów oprócz typowych kolekcji schematów:
Tabele
Kolumny
z konkretnym obiektem
Parametry procedury
Wykaz
Indeksy
Tabele
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| TABLE_GUID | Identyfikator GUID |
| OPIS | String |
| TABLE_PROPID | Int64 |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Kolumny
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| COLUMN_NAME | String |
| COLUMN_GUID | Identyfikator GUID |
| COLUMN_PROPID | Int64 |
| ORDINAL_POSITION | Int64 |
| COLUMN_HASDEFAULT | Wartość logiczna |
| COLUMN_DEFAULT | String |
| COLUMN_FLAGS | Int64 |
| IS_NULLABLE | Wartość logiczna |
| DATA_TYPE | Int32 |
| TYPE_GUID | Identyfikator GUID |
| CHARACTER_MAXIMUM_LENGTH | Int64 |
| CHARACTER_OCTET_LENGTH | Int64 |
| NUMERIC_PRECISION | Int32 |
| NUMERIC_SCALE | Int16 |
| DATETIME_PRECISION | Int64 |
| CHARACTER_SET_CATALOG | String |
| CHARACTER_SET_SCHEMA | String |
| CHARACTER_SET_NAME | String |
| COLLATION_CATALOG | String |
| COLLATION_SCHEMA | String |
| COLLATION_NAME | String |
| DOMAIN_CATALOG | String |
| DOMAIN_SCHEMA | String |
| DOMAIN_NAME | String |
| OPIS | String |
| COLUMN_LCID | Int32 |
| COLUMN_COMPFLAGS | Int32 |
| COLUMN_SORTID | Int32 |
| COLUMN_TDSCOLLATION | Bajt[] |
| IS_COMPUTED | Wartość logiczna |
z konkretnym obiektem
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PROCEDURE_TYPE | Int16 |
| PROCEDURE_DEFINITION | String |
| OPIS | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Parametry procedury
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PARAMETER_NAME | String |
| ORDINAL_POSITION | Int32 |
| PARAMETER_TYPE | Int32 |
| PARAMETER_HASDEFAULT | Wartość logiczna |
| PARAMETER_DEFAULT | String |
| IS_NULLABLE | Wartość logiczna |
| DATA_TYPE | Int32 |
| CHARACTER_MAXIMUM_LENGTH | Int64 |
| CHARACTER_OCTET_LENGTH | Int64 |
| NUMERIC_PRECISION | Int32 |
| NUMERIC_SCALE | Int16 |
| OPIS | String |
| TYPE_NAME | String |
| LOCAL_TYPE_NAME | String |
Wykaz
| ColumnName | DataType |
|---|---|
| CATALOG_NAME | String |
| OPIS | String |
Indeksy
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| INDEX_CATALOG | String |
| INDEX_SCHEMA | String |
| INDEX_NAME | String |
| PRIMARY_KEY | Wartość logiczna |
| UNIKATOWY | Wartość logiczna |
| CLUSTERED | Wartość logiczna |
| TYP | Int32 |
| FILL_FACTOR | Int32 |
| INITIAL_SIZE | Int32 |
| NULL — Wartości | Int32 |
| SORT_BOOKMARKS | Wartość logiczna |
| AUTO_UPDATE | Wartość logiczna |
| NULL_COLLATION | Int32 |
| ORDINAL_POSITION | Int64 |
| COLUMN_NAME | String |
| COLUMN_GUID | Identyfikator GUID |
| COLUMN_PROPID | Int64 |
| SORTOWANIE | Int16 |
| KARDYNALNOŚĆ | Dziesiętne |
| STRON | Int32 |
| FILTER_CONDITION | String |
| ZINTEGROWANE | Wartość logiczna |
Microsoft Oracle OLE DB Provider
Sterownik MICROSOFT Oracle OLE DB 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
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| TABLE_GUID | Identyfikator GUID |
| OPIS | String |
| TABLE_PROPID | Int64 |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Kolumny
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| COLUMN_NAME | String |
| COLUMN_GUID | Identyfikator GUID |
| COLUMN_PROPID | Int64 |
| ORDINAL_POSITION | Int64 |
| COLUMN_HASDEFAULT | Wartość logiczna |
| COLUMN_DEFAULT | String |
| COLUMN_FLAGS | Int64 |
| IS_NULLABLE | Wartość logiczna |
| DATA_TYPE | Int32 |
| TYPE_GUID | Identyfikator GUID |
| CHARACTER_MAXIMUM_LENGTH | Int64 |
| CHARACTER_OCTET_LENGTH | Int64 |
| NUMERIC_PRECISION | Int32 |
| NUMERIC_SCALE | Int16 |
| DATETIME_PRECISION | Int64 |
| CHARACTER_SET_CATALOG | String |
| CHARACTER_SET_SCHEMA | String |
| CHARACTER_SET_NAME | String |
| COLLATION_CATALOG | String |
| COLLATION_SCHEMA | String |
| COLLATION_NAME | String |
| DOMAIN_CATALOG | String |
| DOMAIN_SCHEMA | String |
| DOMAIN_NAME | String |
| OPIS | String |
z konkretnym obiektem
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PROCEDURE_TYPE | Int16 |
| PROCEDURE_DEFINITION | String |
| OPIS | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Kolumny procedury
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| COLUMN_NAME | String |
| COLUMN_GUID | Identyfikator GUID |
| COLUMN_PROPID | Int64 |
| ROWSET_NUMBER | Int64 |
| ORDINAL_POSITION | Int64 |
| IS_NULLABLE | Wartość logiczna |
| DATA_TYPE | Int32 |
| TYPE_GUID | Identyfikator GUID |
| CHARACTER_MAXIMUM_LENGTH | Int64 |
| CHARACTER_OCTET_LENGTH | Int64 |
| NUMERIC_PRECISION | Int32 |
| NUMERIC_SCALE | Int16 |
| OPIS | String |
| PRZECIĄŻENIE | Int16 |
Widoki
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| VIEW_DEFINITION | String |
| CHECK_OPTION | Wartość logiczna |
| IS_UPDATABLE | Wartość logiczna |
| OPIS | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Indeksy
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| INDEX_CATALOG | String |
| INDEX_SCHEMA | String |
| INDEX_NAME | String |
| PRIMARY_KEY | Wartość logiczna |
| UNIKATOWY | Wartość logiczna |
| CLUSTERED | Wartość logiczna |
| TYP | Int32 |
| FILL_FACTOR | Int32 |
| INITIAL_SIZE | Int32 |
| NULL — Wartości | Int32 |
| SORT_BOOKMARKS | Wartość logiczna |
| AUTO_UPDATE | Wartość logiczna |
| NULL_COLLATION | Int32 |
| ORDINAL_POSITION | Int64 |
| COLUMN_NAME | String |
| COLUMN_GUID | Identyfikator GUID |
| COLUMN_PROPID | Int64 |
| SORTOWANIE | Int16 |
| KARDYNALNOŚĆ | Dziesiętne |
| STRON | Int32 |
| FILTER_CONDITION | String |
| ZINTEGROWANE | Wartość logiczna |
Microsoft Jet OLE DB Provider
Sterownik Microsoft Jet OLE DB obsługuje następujące kolekcje schematów oprócz typowych kolekcji schematów:
Tabele
Kolumny
z konkretnym obiektem
Widoki
Indeksy
Tabele
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| TABLE_GUID | Identyfikator GUID |
| OPIS | String |
| TABLE_PROPID | Int64 |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Kolumny
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| COLUMN_NAME | String |
| COLUMN_GUID | Identyfikator GUID |
| COLUMN_PROPID | Int64 |
| ORDINAL_POSITION | Int64 |
| COLUMN_HASDEFAULT | Wartość logiczna |
| COLUMN_DEFAULT | String |
| COLUMN_FLAGS | Int64 |
| IS_NULLABLE | Wartość logiczna |
| DATA_TYPE | Int32 |
| TYPE_GUID | Identyfikator GUID |
| CHARACTER_MAXIMUM_LENGTH | Int64 |
| CHARACTER_OCTET_LENGTH | Int64 |
| NUMERIC_PRECISION | Int32 |
| NUMERIC_SCALE | Int16 |
| DATETIME_PRECISION | Int64 |
| CHARACTER_SET_CATALOG | String |
| CHARACTER_SET_SCHEMA | String |
| CHARACTER_SET_NAME | String |
| COLLATION_CATALOG | String |
| COLLATION_SCHEMA | String |
| COLLATION_NAME | String |
| DOMAIN_CATALOG | String |
| DOMAIN_SCHEMA | String |
| DOMAIN_NAME | String |
| OPIS | String |
z konkretnym obiektem
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PROCEDURE_TYPE | Int16 |
| PROCEDURE_DEFINITION | String |
| OPIS | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Widoki
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| VIEW_DEFINITION | String |
| CHECK_OPTION | Wartość logiczna |
| IS_UPDATABLE | Wartość logiczna |
| OPIS | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Indeksy
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| INDEX_CATALOG | String |
| INDEX_SCHEMA | String |
| INDEX_NAME | String |
| PRIMARY_KEY | Wartość logiczna |
| UNIKATOWY | Wartość logiczna |
| CLUSTERED | Wartość logiczna |
| TYP | Int32 |
| FILL_FACTOR | Int32 |
| INITIAL_SIZE | Int32 |
| NULL — Wartości | Int32 |
| SORT_BOOKMARKS | Wartość logiczna |
| AUTO_UPDATE | Wartość logiczna |
| NULL_COLLATION | Int32 |
| ORDINAL_POSITION | Int64 |
| COLUMN_NAME | String |
| COLUMN_GUID | Identyfikator GUID |
| COLUMN_PROPID | Int64 |
| SORTOWANIE | Int16 |
| KARDYNALNOŚĆ | Dziesiętne |
| STRON | Int32 |
| FILTER_CONDITION | String |
| ZINTEGROWANE | Wartość logiczna |