Colecciones de esquemas ODBC (ADO.NET)
Actualización: November 2007
En esta sección se describe la compatibilidad de las colecciones de esquemas con los controladores ODBC de Microsoft SQL Server, Oracle y Microsoft Jet.
Controlador ODBC de Microsoft SQL Server
El controlador ODBC de Microsoft SQL Server admite, además de las colecciones de esquemas comunes, las siguientes colecciones de esquemas específicas:
Tablas
Índices
Columnas
Procedimientos
ProcedureColumns
ProcedureParameters
Vistas
Tablas y vistas
ColumnName |
DataType |
|---|---|
TABLE_CAT |
String |
TABLE_SCHEM |
String |
TABLE_NAME |
String |
TABLE_TYPE |
String |
REMARKS |
String |
Índices
ColumnName |
DataType |
|---|---|
TABLE_CAT |
String |
TABLE_SCHEM |
String |
TABLE_NAME |
String |
NON_UNIQUE |
Int16 |
INDEX_QUALIFIER |
String |
INDEX_NAME |
String |
TYPE |
Int16 |
ORDINAL_POSITION |
Int16 |
COLUMN_NAME |
String |
ASC_OR_DESC |
String |
CARDINATLITY |
Int32 |
PAGES |
Int32 |
FILTER_CONDITION |
String |
SS_TYPE_SCHEMA |
String |
SS_DATA_TYPE |
Byte |
Columnas
ColumnName |
DataType |
|---|---|
TABLE_CAT |
String |
TABLE_SCHEM |
String |
TABLE_NAME |
String |
COLUMN_NAME |
String |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
COLUMN_SIZE |
Int32 |
BUFFER_LENGTH |
Int32 |
DECIMAL_DIGITS |
Int16 |
NUM_PREC_RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
COLUMN_DEF |
String |
SQL_DATA_TYPE |
Int16 |
SQL_DATETIME_SUB |
Int16 |
CHAR_OCTET_LENGTH |
Int32 |
ORDINAL_POSITION |
Int32 |
IS_NULLABLE |
String |
SS_TYPE_CATALOG |
String |
SS_TYPE_SCHEMA |
String |
SS_DATA_TYPE |
Byte |
Procedimientos
ColumnName |
DataType |
|---|---|
PROCEDURE_CAT |
String |
PROCEDURE_SCHEM |
String |
PROCEDURE_NAME |
String |
NUM_INPUT_PARAMS |
Int32 |
NUM_OUTPUT_PARAMS |
Int32 |
NUM_RESULT_SETS |
Int32 |
REMARKS |
String |
PROCEDURE_TYPE |
Int16 |
ProcedureColumns
ColumnName |
DataType |
|---|---|
PROCEDURE_CAT |
String |
PROCEDURE_SCHEM |
String |
PROCEDURE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_TYPE |
Int16 |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
COLUMN_SIZE |
Int32 |
BUFFER_LENGTH |
Int32 |
DECIMAL_DIGITS |
Int16 |
NUM_PREC_RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
COLUMN_DEF |
String |
SQL_DATA_TYPE |
Int16 |
SQL_DATETIME_SUB |
Int16 |
CHAR_OCTET_LENGTH |
Int32 |
ORDINAL_POSITION |
Int32 |
IS_NULLABLE |
String |
SS_TYPE_CATALOG |
String |
SS_TYPE_SCHEMA |
String |
SS_DATA_TYPE |
Byte |
ProcedureParameters
ColumnName |
DataType |
|---|---|
PROCEDURE_CAT |
String |
PROCEDURE_SCHEM |
String |
PROCEDURE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_TYPE |
Int16 |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
COLUMN_SIZE |
Int32 |
BUFFER_LENGTH |
Int32 |
DECIMAL_DIGITS |
Int16 |
NUM_PREC_RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
COLUMN_DEF |
String |
SQL_DATA_TYPE |
Int16 |
SQL_DATETIME_SUB |
Int16 |
CHAR_OCTET_LENGTH |
Int32 |
ORDINAL_POSITION |
Int32 |
IS_NULLABLE |
String |
SS_TYPE_CATALOG |
String |
SS_TYPE_SCHEMA |
String |
SS_DATA_TYPE |
Byte |
Controlador ODBC para Oracle de Microsoft
El controlador ODBC para Oracle de Microsoft SQL Server admite, además de las colecciones de esquemas comunes, las siguientes colecciones de esquemas específicas:
Tablas
Columnas
Procedimientos
ProcedureColumns
ProcedureParameters
Vistas
Índices
Tablas y vistas
ColumnName |
DataType |
|---|---|
TABLE_QUALIFIER |
String |
TABLE_OWNER |
String |
TABLE_NAME |
String |
TABLE_TYPE |
String |
REMARKS |
String |
Columnas
ColumnName |
DataType |
|---|---|
TABLE_QUALIFIER |
String |
TABLE_OWNER |
String |
TABLE_NAME |
String |
COLUMN_NAME |
String |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
PRECISION |
Int32 |
LENGTH |
Int32 |
SCALE |
Int16 |
RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
ORDINAL_POSITION |
Int32 |
Procedimientos
ColumnName |
DataType |
|---|---|
PROCEDURE_QUALIFIER |
String |
PROCEDURE_OWNER |
String |
PROCEDURE_NAME |
String |
NUM_INPUT_PARAMS |
Int16 |
NUM_OUTPUT_PARAMS |
Int16 |
NUM_RESULT_SETS |
Int16 |
REMARKS |
String |
PROCEDURE_TYPE |
Int16 |
ProcedureColumns
ColumnName |
DataType |
|---|---|
PROCEDURE_QUALIFIER |
String |
PROCEDURE_OWNER |
String |
PROCEDURE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_TYPE |
Int16 |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
PRECISION |
Int32 |
LENGTH |
Int32 |
SCALE |
Int16 |
RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
OVERLOAD |
Int32 |
ORDINAL_POSITION |
Int32 |
Controlador ODBC de Microsoft para Jet
El controlador ODBC de Microsoft para Jet admite, además de las colecciones de esquemas comunes, las siguientes colecciones de esquemas específicas:
Tablas
Índices
Columnas
Procedimientos
ProcedureColumns
ProcedureParameters
Vistas
Tablas y vistas
ColumnName |
DataType |
|---|---|
TABLE_QUALIFIER |
String |
TABLE_OWNER |
String |
TABLE_NAME |
String |
TABLE_TYPE |
String |
REMARKS |
String |
Columnas
ColumnName |
DataType |
|---|---|
TABLE_QUALIFIER |
String |
TABLE_OWNER |
String |
TABLE_NAME |
String |
COLUMN_NAME |
String |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
PRECISION |
Int32 |
LENGTH |
Int32 |
SCALE |
Int16 |
RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
ORDINAL_POSITION |
Int32 |
Procedimientos
ColumnName |
DataType |
|---|---|
PROCEDURE_QUALIFIER |
String |
PROCEDURE_OWNER |
String |
PROCEDURE_NAME |
String |
NUM_INPUT_PARAMS |
Int16 |
NUM_OUTPUT_PARAMS |
Int16 |
NUM_RESULT_SETS |
Int16 |
REMARKS |
String |
PROCEDURE_TYPE |
Int16 |
ProcedureColumns
ColumnName |
DataType |
|---|---|
PROCEDURE_QUALIFIER |
String |
PROCEDURE_OWNER |
String |
PROCEDURE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_TYPE |
Int16 |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
PRECISION |
Int32 |
LENGTH |
Int32 |
SCALE |
Int16 |
RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
OVERLOAD |
Int32 |
ORDINAL_POSITION |
Int32 |
ProcedureParameters
ColumnName |
DataType |
|---|---|
PROCEDURE_CAT |
String |
PROCEDURE_SCHEM |
String |
PROCEDURE_NAME |
String |
COLUMN_NAME |
String |
COLUMN_TYPE |
Int16 |
DATA_TYPE |
Int16 |
TYPE_NAME |
String |
COLUMN_SIZE |
Int32 |
BUFFER_LENGTH |
Int32 |
DECIMAL_DIGITS |
Int16 |
NUM_PREC_RADIX |
Int16 |
NULLABLE |
Int16 |
REMARKS |
String |
COLUMN_DEF |
String |
SQL_DATA_TYPE |
Int16 |
SQL_DATETIME_SUB |
Int16 |
CHAR_OCTET_LENGTH |
Int32 |
ORDINAL_POSITION |
Int32 |
IS_NULLABLE |
String |