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 |