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

Consulte también