OLE DB-schemaverzamelingen
In deze sectie wordt ondersteuning voor schemaverzameling besproken voor de OLE DB-providers voor Microsoft SQL Server, Oracle en Microsoft Jet.
Microsoft SQL Server OLE DB-provider
Het OLE DB-stuurprogramma van Microsoft SQL Server ondersteunt de volgende specifieke schemaverzamelingen naast de algemene schemaverzamelingen:
Tabellen
Kolommen
Procedures
ProcedureParameters
Catalogus
Indexen
Tabellen
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABELNAAM | String |
| TABLE_TYPE | String |
| TABLE_GUID | Guid |
| BESCHRIJVING | String |
| TABLE_PROPID | Int64 |
| DATE_CREATED | Datum en tijd |
| DATE_MODIFIED | Datum en tijd |
Kolommen
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABELNAAM | String |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| ORDINAL_POSITION | Int64 |
| COLUMN_HASDEFAULT | Booleaanse waarde |
| COLUMN_DEFAULT | String |
| COLUMN_FLAGS | Int64 |
| IS_NULLABLE | Booleaanse waarde |
| DATA_TYPE | Int32 |
| TYPE_GUID | 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 |
| BESCHRIJVING | String |
| COLUMN_LCID | Int32 |
| COLUMN_COMPFLAGS | Int32 |
| COLUMN_SORTID | Int32 |
| COLUMN_TDSCOLLATION | Byte[] |
| IS_COMPUTED | Booleaanse waarde |
Procedures
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PROCEDURE_TYPE | Int16 |
| PROCEDURE_DEFINITION | String |
| BESCHRIJVING | String |
| DATE_CREATED | Datum en tijd |
| DATE_MODIFIED | Datum en tijd |
ProcedureParameters
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PARAMETER_NAME | String |
| ORDINAL_POSITION | Int32 |
| PARAMETER_TYPE | Int32 |
| PARAMETER_HASDEFAULT | Booleaanse waarde |
| PARAMETER_DEFAULT | String |
| IS_NULLABLE | Booleaanse waarde |
| DATA_TYPE | Int32 |
| CHARACTER_MAXIMUM_LENGTH | Int64 |
| CHARACTER_OCTET_LENGTH | Int64 |
| NUMERIC_PRECISION | Int32 |
| NUMERIC_SCALE | Int16 |
| BESCHRIJVING | String |
| TYPE_NAME | String |
| LOCAL_TYPE_NAME | String |
Catalogus
| ColumnName | DataType |
|---|---|
| CATALOG_NAME | String |
| BESCHRIJVING | String |
Indexen
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABELNAAM | String |
| INDEX_CATALOG | String |
| INDEX_SCHEMA | String |
| INDEX_NAME | String |
| PRIMARY_KEY | Booleaanse waarde |
| UNIEKE | Booleaanse waarde |
| GECLUSTERDE | Booleaanse waarde |
| TYPE | Int32 |
| FILL_FACTOR | Int32 |
| INITIAL_SIZE | Int32 |
| NULLS | Int32 |
| SORT_BOOKMARKS | Booleaanse waarde |
| AUTO_UPDATE | Booleaanse waarde |
| NULL_COLLATION | Int32 |
| ORDINAL_POSITION | Int64 |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| SORTERING | Int16 |
| KARDINALITEIT | Decimal |
| BLZ | Int32 |
| FILTER_CONDITION | String |
| GEÏNTEGREERDE | Booleaanse waarde |
Microsoft Oracle OLE DB-provider
Het Microsoft Oracle OLE DB-stuurprogramma ondersteunt naast de algemene schemaverzamelingen de volgende specifieke schemaverzamelingen:
Tabellen
Kolommen
Procedures
ProcedureColumns
ProcedureParameters
Weergaven
Indexen
Tabellen
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABELNAAM | String |
| TABLE_TYPE | String |
| TABLE_GUID | Guid |
| BESCHRIJVING | String |
| TABLE_PROPID | Int64 |
| DATE_CREATED | Datum en tijd |
| DATE_MODIFIED | Datum en tijd |
Kolommen
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABELNAAM | String |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| ORDINAL_POSITION | Int64 |
| COLUMN_HASDEFAULT | Booleaanse waarde |
| COLUMN_DEFAULT | String |
| COLUMN_FLAGS | Int64 |
| IS_NULLABLE | Booleaanse waarde |
| DATA_TYPE | Int32 |
| TYPE_GUID | 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 |
| BESCHRIJVING | String |
Procedures
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PROCEDURE_TYPE | Int16 |
| PROCEDURE_DEFINITION | String |
| BESCHRIJVING | String |
| DATE_CREATED | Datum en tijd |
| DATE_MODIFIED | Datum en tijd |
ProcedureColumns
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| ROWSET_NUMBER | Int64 |
| ORDINAL_POSITION | Int64 |
| IS_NULLABLE | Booleaanse waarde |
| DATA_TYPE | Int32 |
| TYPE_GUID | Guid |
| CHARACTER_MAXIMUM_LENGTH | Int64 |
| CHARACTER_OCTET_LENGTH | Int64 |
| NUMERIC_PRECISION | Int32 |
| NUMERIC_SCALE | Int16 |
| BESCHRIJVING | String |
| OVERBELASTING | Int16 |
Weergaven
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABELNAAM | String |
| VIEW_DEFINITION | String |
| CHECK_OPTION | Booleaanse waarde |
| IS_UPDATABLE | Booleaanse waarde |
| BESCHRIJVING | String |
| DATE_CREATED | Datum en tijd |
| DATE_MODIFIED | Datum en tijd |
Indexen
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABELNAAM | String |
| INDEX_CATALOG | String |
| INDEX_SCHEMA | String |
| INDEX_NAME | String |
| PRIMARY_KEY | Booleaanse waarde |
| UNIEKE | Booleaanse waarde |
| GECLUSTERDE | Booleaanse waarde |
| TYPE | Int32 |
| FILL_FACTOR | Int32 |
| INITIAL_SIZE | Int32 |
| NULLS | Int32 |
| SORT_BOOKMARKS | Booleaanse waarde |
| AUTO_UPDATE | Booleaanse waarde |
| NULL_COLLATION | Int32 |
| ORDINAL_POSITION | Int64 |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| SORTERING | Int16 |
| KARDINALITEIT | Decimal |
| BLZ | Int32 |
| FILTER_CONDITION | String |
| GEÏNTEGREERDE | Booleaanse waarde |
Microsoft Jet OLE DB-provider
Het Microsoft Jet OLE DB-stuurprogramma ondersteunt de volgende specifieke schemaverzamelingen naast de algemene schemaverzamelingen:
Tabellen
Kolommen
Procedures
Weergaven
Indexen
Tabellen
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABELNAAM | String |
| TABLE_TYPE | String |
| TABLE_GUID | Guid |
| BESCHRIJVING | String |
| TABLE_PROPID | Int64 |
| DATE_CREATED | Datum en tijd |
| DATE_MODIFIED | Datum en tijd |
Kolommen
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABELNAAM | String |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| ORDINAL_POSITION | Int64 |
| COLUMN_HASDEFAULT | Booleaanse waarde |
| COLUMN_DEFAULT | String |
| COLUMN_FLAGS | Int64 |
| IS_NULLABLE | Booleaanse waarde |
| DATA_TYPE | Int32 |
| TYPE_GUID | 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 |
| BESCHRIJVING | String |
Procedures
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PROCEDURE_TYPE | Int16 |
| PROCEDURE_DEFINITION | String |
| BESCHRIJVING | String |
| DATE_CREATED | Datum en tijd |
| DATE_MODIFIED | Datum en tijd |
Weergaven
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABELNAAM | String |
| VIEW_DEFINITION | String |
| CHECK_OPTION | Booleaanse waarde |
| IS_UPDATABLE | Booleaanse waarde |
| BESCHRIJVING | String |
| DATE_CREATED | Datum en tijd |
| DATE_MODIFIED | Datum en tijd |
Indexen
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABELNAAM | String |
| INDEX_CATALOG | String |
| INDEX_SCHEMA | String |
| INDEX_NAME | String |
| PRIMARY_KEY | Booleaanse waarde |
| UNIEKE | Booleaanse waarde |
| GECLUSTERDE | Booleaanse waarde |
| TYPE | Int32 |
| FILL_FACTOR | Int32 |
| INITIAL_SIZE | Int32 |
| NULLS | Int32 |
| SORT_BOOKMARKS | Booleaanse waarde |
| AUTO_UPDATE | Booleaanse waarde |
| NULL_COLLATION | Int32 |
| ORDINAL_POSITION | Int64 |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| SORTERING | Int16 |
| KARDINALITEIT | Decimal |
| BLZ | Int32 |
| FILTER_CONDITION | String |
| GEÏNTEGREERDE | Booleaanse waarde |