Colecciones de esquemas de OLE DB
En esta sección se describe la compatibilidad de las colecciones de esquemas con los proveedores OLE DB de Microsoft SQL Server, Oracle y Microsoft Jet.
Proveedor OLE DB para Microsoft SQL Server
El controlador OLE DB de Microsoft SQL Server admite, además de las colecciones de esquemas comunes, las siguientes colecciones de esquemas específicas:
Tablas
Columnas
Procedimientos
ProcedureParameters
Catálogo
Índices
Tablas
| 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 |
Columnas
| 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 |
Procedimientos
| 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 |
Catálogo
| ColumnName | DataType |
|---|---|
| CATALOG_NAME | String |
| DESCRIPTION | String |
Índices
| 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 |
Proveedor OLE DB de Microsoft para Oracle
El controlador OLE DB de Microsoft para Oracle admite, además de las colecciones de esquemas comunes, las siguientes colecciones de esquemas específicas:
Tablas
Columnas
Procedimientos
ProcedureColumns
ProcedureParameters
Vistas
Índices
Tablas
| 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 |
Columnas
| 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 |
Procedimientos
| 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 |
Vistas
| 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 |
Índices
| 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 |
Proveedor OLE DB de Microsoft para Jet
El controlador OLE DB de Microsoft para Jet admite, además de las colecciones de esquemas comunes, las siguientes colecciones de esquemas específicas:
Tablas
Columnas
Procedimientos
Vistas
Índices
Tablas
| 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 |
Columnas
| 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 |
Procedimientos
| 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 |
Vistas
| 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 |
Índices
| 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 |