Colecciones de esquemas de OLE DB (OLE.NET)
Actualización: November 2007
En esta sección se describe la compatibilidad de las colecciones de esquemas con los proveedore 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 |
Booleano |
COLUMN_DEFAULT |
String |
COLUMN_FLAGS |
Int64 |
IS_NULLABLE |
Booleano |
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 |
Booleano |
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 |
Booleano |
PARAMETER_DEFAULT |
String |
IS_NULLABLE |
Booleano |
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 |
Booleano |
UNIQUE |
Booleano |
CLUSTERED |
Booleano |
TYPE |
Int32 |
FILL_FACTOR |
Int32 |
INITIAL_SIZE |
Int32 |
NULLS |
Int32 |
SORT_BOOKMARKS |
Booleano |
AUTO_UPDATE |
Booleano |
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 |
Booleano |
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 |
Booleano |
COLUMN_DEFAULT |
String |
COLUMN_FLAGS |
Int64 |
IS_NULLABLE |
Booleano |
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 |
Booleano |
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 |
Booleano |
IS_UPDATABLE |
Booleano |
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 |
Booleano |
UNIQUE |
Booleano |
CLUSTERED |
Booleano |
TYPE |
Int32 |
FILL_FACTOR |
Int32 |
INITIAL_SIZE |
Int32 |
NULLS |
Int32 |
SORT_BOOKMARKS |
Booleano |
AUTO_UPDATE |
Booleano |
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 |
Booleano |
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 |
Booleano |
COLUMN_DEFAULT |
String |
COLUMN_FLAGS |
Int64 |
IS_NULLABLE |
Booleano |
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 |
Booleano |
IS_UPDATABLE |
Booleano |
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 |
Booleano |
UNIQUE |
Booleano |
CLUSTERED |
Booleano |
TYPE |
Int32 |
FILL_FACTOR |
Int32 |
INITIAL_SIZE |
Int32 |
NULLS |
Int32 |
SORT_BOOKMARKS |
Booleano |
AUTO_UPDATE |
Booleano |
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 |
Booleano |