Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This section discusses schema collection support for the OLE DB providers for Microsoft SQL Server, Oracle, and Microsoft Jet.
Microsoft SQL Server OLE DB Provider
The Microsoft SQL Server OLE DB Driver supports the following specific schema collections in addition to the common schema collections:
Tables
Columns
Procedures
ProcedureParameters
Catalog
Indexes
Tables
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| TABLE_GUID | Guid |
| DESCRIPTION | String |
| TABLE_PROPID | Int64 |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Columns
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| ORDINAL_POSITION | Int64 |
| COLUMN_HASDEFAULT | Boolean |
| COLUMN_DEFAULT | String |
| COLUMN_FLAGS | Int64 |
| IS_NULLABLE | Boolean |
| 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 |
| DESCRIPTION | String |
| COLUMN_LCID | Int32 |
| COLUMN_COMPFLAGS | Int32 |
| COLUMN_SORTID | Int32 |
| COLUMN_TDSCOLLATION | Byte[] |
| IS_COMPUTED | Boolean |
Procedures
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PROCEDURE_TYPE | Int16 |
| PROCEDURE_DEFINITION | String |
| DESCRIPTION | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
ProcedureParameters
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PARAMETER_NAME | String |
| ORDINAL_POSITION | Int32 |
| PARAMETER_TYPE | Int32 |
| PARAMETER_HASDEFAULT | Boolean |
| PARAMETER_DEFAULT | String |
| IS_NULLABLE | Boolean |
| DATA_TYPE | Int32 |
| CHARACTER_MAXIMUM_LENGTH | Int64 |
| CHARACTER_OCTET_LENGTH | Int64 |
| NUMERIC_PRECISION | Int32 |
| NUMERIC_SCALE | Int16 |
| DESCRIPTION | String |
| TYPE_NAME | String |
| LOCAL_TYPE_NAME | String |
Catalog
| ColumnName | DataType |
|---|---|
| CATALOG_NAME | String |
| DESCRIPTION | String |
Indexes
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| INDEX_CATALOG | String |
| INDEX_SCHEMA | String |
| INDEX_NAME | String |
| PRIMARY_KEY | Boolean |
| UNIQUE | Boolean |
| CLUSTERED | Boolean |
| TYPE | Int32 |
| FILL_FACTOR | Int32 |
| INITIAL_SIZE | Int32 |
| NULLS | Int32 |
| SORT_BOOKMARKS | Boolean |
| AUTO_UPDATE | Boolean |
| NULL_COLLATION | Int32 |
| ORDINAL_POSITION | Int64 |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| COLLATION | Int16 |
| CARDINALITY | Decimal |
| PAGES | Int32 |
| FILTER_CONDITION | String |
| INTEGRATED | Boolean |
Microsoft Oracle OLE DB Provider
The Microsoft Oracle OLE DB Driver supports the following specific schema collections in addition to the common schema collections:
Tables
Columns
Procedures
ProcedureColumns
ProcedureParameters
Views
Indexes
Tables
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| TABLE_GUID | Guid |
| DESCRIPTION | String |
| TABLE_PROPID | Int64 |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Columns
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| ORDINAL_POSITION | Int64 |
| COLUMN_HASDEFAULT | Boolean |
| COLUMN_DEFAULT | String |
| COLUMN_FLAGS | Int64 |
| IS_NULLABLE | Boolean |
| 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 |
| DESCRIPTION | String |
Procedures
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PROCEDURE_TYPE | Int16 |
| PROCEDURE_DEFINITION | String |
| DESCRIPTION | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
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 | Boolean |
| DATA_TYPE | Int32 |
| TYPE_GUID | Guid |
| CHARACTER_MAXIMUM_LENGTH | Int64 |
| CHARACTER_OCTET_LENGTH | Int64 |
| NUMERIC_PRECISION | Int32 |
| NUMERIC_SCALE | Int16 |
| DESCRIPTION | String |
| OVERLOAD | Int16 |
Views
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| VIEW_DEFINITION | String |
| CHECK_OPTION | Boolean |
| IS_UPDATABLE | Boolean |
| DESCRIPTION | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Indexes
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| INDEX_CATALOG | String |
| INDEX_SCHEMA | String |
| INDEX_NAME | String |
| PRIMARY_KEY | Boolean |
| UNIQUE | Boolean |
| CLUSTERED | Boolean |
| TYPE | Int32 |
| FILL_FACTOR | Int32 |
| INITIAL_SIZE | Int32 |
| NULLS | Int32 |
| SORT_BOOKMARKS | Boolean |
| AUTO_UPDATE | Boolean |
| NULL_COLLATION | Int32 |
| ORDINAL_POSITION | Int64 |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| COLLATION | Int16 |
| CARDINALITY | Decimal |
| PAGES | Int32 |
| FILTER_CONDITION | String |
| INTEGRATED | Boolean |
Microsoft Jet OLE DB Provider
The Microsoft Jet OLE DB Driver supports the following specific schema collections in addition to the common schema collections:
Tables
Columns
Procedures
Views
Indexes
Tables
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| TABLE_TYPE | String |
| TABLE_GUID | Guid |
| DESCRIPTION | String |
| TABLE_PROPID | Int64 |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Columns
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| ORDINAL_POSITION | Int64 |
| COLUMN_HASDEFAULT | Boolean |
| COLUMN_DEFAULT | String |
| COLUMN_FLAGS | Int64 |
| IS_NULLABLE | Boolean |
| 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 |
| DESCRIPTION | String |
Procedures
| ColumnName | DataType |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PROCEDURE_TYPE | Int16 |
| PROCEDURE_DEFINITION | String |
| DESCRIPTION | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Views
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| VIEW_DEFINITION | String |
| CHECK_OPTION | Boolean |
| IS_UPDATABLE | Boolean |
| DESCRIPTION | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
Indexes
| ColumnName | DataType |
|---|---|
| TABLE_CATALOG | String |
| TABLE_SCHEMA | String |
| TABLE_NAME | String |
| INDEX_CATALOG | String |
| INDEX_SCHEMA | String |
| INDEX_NAME | String |
| PRIMARY_KEY | Boolean |
| UNIQUE | Boolean |
| CLUSTERED | Boolean |
| TYPE | Int32 |
| FILL_FACTOR | Int32 |
| INITIAL_SIZE | Int32 |
| NULLS | Int32 |
| SORT_BOOKMARKS | Boolean |
| AUTO_UPDATE | Boolean |
| NULL_COLLATION | Int32 |
| ORDINAL_POSITION | Int64 |
| COLUMN_NAME | String |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| COLLATION | Int16 |
| CARDINALITY | Decimal |
| PAGES | Int32 |
| FILTER_CONDITION | String |
| INTEGRATED | Boolean |