Note
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang mag-sign in o magpalit ng mga direktoryo.
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang baguhin ang mga direktoryo.
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 |