Raccolte di schemi ODBCODBC Schema Collections

Contenuto della sezione viene descritto il supporto delle raccolte di schemi per driver ODBC per Microsoft SQL Server, Oracle e Microsoft Jet.This section discusses schema collection support for the ODBC drivers for Microsoft SQL Server, Oracle, and Microsoft Jet.

Driver ODBC di Microsoft SQL ServerMicrosoft SQL Server ODBC Driver

Il Driver ODBC di Microsoft SQL Server supporta le raccolte di schemi specifici seguenti oltre alle raccolte di schemi comuni:The Microsoft SQL Server ODBC Driver supports the following specific schema collections in addition to the common schema collections:

  • TabelleTables

  • IndexesIndexes

  • ColonneColumns

  • ProcedureProcedures

  • ProcedureColumnsProcedureColumns

  • ProcedureParametersProcedureParameters

  • VisualizzazioniViews

Tables e ViewsTables and Views

Nome colonnaColumnName Tipo di datiDataType
TABLE_CATTABLE_CAT StringString
TABLE_SCHEMTABLE_SCHEM StringString
TABLE_NAMETABLE_NAME StringString
TABLE_TYPETABLE_TYPE StringString
REMARKSREMARKS StringString

IndexesIndexes

Nome colonnaColumnName Tipo di datiDataType
TABLE_CATTABLE_CAT StringString
TABLE_SCHEMTABLE_SCHEM StringString
TABLE_NAMETABLE_NAME StringString
NON_UNIQUENON_UNIQUE Int16Int16
INDEX_QUALIFIERINDEX_QUALIFIER StringString
INDEX_NAMEINDEX_NAME StringString
TYPETYPE Int16Int16
ORDINAL_POSITIONORDINAL_POSITION Int16Int16
COLUMN_NAMECOLUMN_NAME StringString
ASC_OR_DESCASC_OR_DESC StringString
CARDINATLITYCARDINATLITY Int32Int32
PAGESPAGES Int32Int32
FILTER_CONDITIONFILTER_CONDITION StringString
SS_TYPE_SCHEMASS_TYPE_SCHEMA StringString
SS_DATA_TYPESS_DATA_TYPE ByteByte

ColonneColumns

Nome colonnaColumnName Tipo di datiDataType
TABLE_CATTABLE_CAT StringString
TABLE_SCHEMTABLE_SCHEM StringString
TABLE_NAMETABLE_NAME StringString
COLUMN_NAMECOLUMN_NAME StringString
DATA_TYPEDATA_TYPE Int16Int16
TYPE_NAMETYPE_NAME StringString
COLUMN_SIZECOLUMN_SIZE Int32Int32
BUFFER_LENGTHBUFFER_LENGTH Int32Int32
DECIMAL_DIGITSDECIMAL_DIGITS Int16Int16
NUM_PREC_RADIXNUM_PREC_RADIX Int16Int16
NULLABLENULLABLE Int16Int16
REMARKSREMARKS StringString
COLUMN_DEFCOLUMN_DEF StringString
SQL_DATA_TYPESQL_DATA_TYPE Int16Int16
SQL_DATETIME_SUBSQL_DATETIME_SUB Int16Int16
CHAR_OCTET_LENGTHCHAR_OCTET_LENGTH Int32Int32
ORDINAL_POSITIONORDINAL_POSITION Int32Int32
IS_NULLABLEIS_NULLABLE StringString
SS_TYPE_CATALOGSS_TYPE_CATALOG StringString
SS_TYPE_SCHEMASS_TYPE_SCHEMA StringString
SS_DATA_TYPESS_DATA_TYPE ByteByte

ProcedureProcedures

Nome colonnaColumnName Tipo di datiDataType
PROCEDURE_CATPROCEDURE_CAT StringString
PROCEDURE_SCHEMPROCEDURE_SCHEM StringString
PROCEDURE_NAMEPROCEDURE_NAME StringString
NUM_INPUT_PARAMSNUM_INPUT_PARAMS Int32Int32
NUM_OUTPUT_PARAMSNUM_OUTPUT_PARAMS Int32Int32
NUM_RESULT_SETSNUM_RESULT_SETS Int32Int32
REMARKSREMARKS StringString
PROCEDURE_TYPEPROCEDURE_TYPE Int16Int16

ProcedureColumnsProcedureColumns

Nome colonnaColumnName Tipo di datiDataType
PROCEDURE_CATPROCEDURE_CAT StringString
PROCEDURE_SCHEMPROCEDURE_SCHEM StringString
PROCEDURE_NAMEPROCEDURE_NAME StringString
COLUMN_NAMECOLUMN_NAME StringString
COLUMN_TYPECOLUMN_TYPE Int16Int16
DATA_TYPEDATA_TYPE Int16Int16
TYPE_NAMETYPE_NAME StringString
COLUMN_SIZECOLUMN_SIZE Int32Int32
BUFFER_LENGTHBUFFER_LENGTH Int32Int32
DECIMAL_DIGITSDECIMAL_DIGITS Int16Int16
NUM_PREC_RADIXNUM_PREC_RADIX Int16Int16
NULLABLENULLABLE Int16Int16
REMARKSREMARKS StringString
COLUMN_DEFCOLUMN_DEF StringString
SQL_DATA_TYPESQL_DATA_TYPE Int16Int16
SQL_DATETIME_SUBSQL_DATETIME_SUB Int16Int16
CHAR_OCTET_LENGTHCHAR_OCTET_LENGTH Int32Int32
ORDINAL_POSITIONORDINAL_POSITION Int32Int32
IS_NULLABLEIS_NULLABLE StringString
SS_TYPE_CATALOGSS_TYPE_CATALOG StringString
SS_TYPE_SCHEMASS_TYPE_SCHEMA StringString
SS_DATA_TYPESS_DATA_TYPE ByteByte

ProcedureParametersProcedureParameters

Nome colonnaColumnName Tipo di datiDataType
PROCEDURE_CATPROCEDURE_CAT StringString
PROCEDURE_SCHEMPROCEDURE_SCHEM StringString
PROCEDURE_NAMEPROCEDURE_NAME StringString
COLUMN_NAMECOLUMN_NAME StringString
COLUMN_TYPECOLUMN_TYPE Int16Int16
DATA_TYPEDATA_TYPE Int16Int16
TYPE_NAMETYPE_NAME StringString
COLUMN_SIZECOLUMN_SIZE Int32Int32
BUFFER_LENGTHBUFFER_LENGTH Int32Int32
DECIMAL_DIGITSDECIMAL_DIGITS Int16Int16
NUM_PREC_RADIXNUM_PREC_RADIX Int16Int16
NULLABLENULLABLE Int16Int16
REMARKSREMARKS StringString
COLUMN_DEFCOLUMN_DEF StringString
SQL_DATA_TYPESQL_DATA_TYPE Int16Int16
SQL_DATETIME_SUBSQL_DATETIME_SUB Int16Int16
CHAR_OCTET_LENGTHCHAR_OCTET_LENGTH Int32Int32
ORDINAL_POSITIONORDINAL_POSITION Int32Int32
IS_NULLABLEIS_NULLABLE StringString
SS_TYPE_CATALOGSS_TYPE_CATALOG StringString
SS_TYPE_SCHEMASS_TYPE_SCHEMA StringString
SS_DATA_TYPESS_DATA_TYPE ByteByte

Driver Microsoft ODBC per OracleMicrosoft Oracle ODBC Driver

Il Driver ODBC di Microsoft SQL Server Oracle supporta le raccolte di schemi specifici seguenti oltre alle raccolte di schemi comuni:The Microsoft SQL Server Oracle ODBC Driver supports the following specific schema collections in addition to the common schema collections:

  • TabelleTables

  • ColonneColumns

  • ProcedureProcedures

  • ProcedureColumnsProcedureColumns

  • ProcedureParametersProcedureParameters

  • VisualizzazioniViews

  • IndexesIndexes

Tables e ViewsTables and Views

Nome colonnaColumnName Tipo di datiDataType
TABLE_QUALIFIERTABLE_QUALIFIER StringString
TABLE_OWNERTABLE_OWNER StringString
TABLE_NAMETABLE_NAME StringString
TABLE_TYPETABLE_TYPE StringString
REMARKSREMARKS StringString

ColonneColumns

Nome colonnaColumnName Tipo di datiDataType
TABLE_QUALIFIERTABLE_QUALIFIER StringString
TABLE_OWNERTABLE_OWNER StringString
TABLE_NAMETABLE_NAME StringString
COLUMN_NAMECOLUMN_NAME StringString
DATA_TYPEDATA_TYPE Int16Int16
TYPE_NAMETYPE_NAME StringString
PRECISIONPRECISION Int32Int32
LENGTHLENGTH Int32Int32
SCALESCALE Int16Int16
RADIXRADIX Int16Int16
NULLABLENULLABLE Int16Int16
REMARKSREMARKS StringString
ORDINAL_POSITIONORDINAL_POSITION Int32Int32

ProcedureProcedures

Nome colonnaColumnName Tipo di datiDataType
PROCEDURE_QUALIFIERPROCEDURE_QUALIFIER StringString
PROCEDURE_OWNERPROCEDURE_OWNER StringString
PROCEDURE_NAMEPROCEDURE_NAME StringString
NUM_INPUT_PARAMSNUM_INPUT_PARAMS Int16Int16
NUM_OUTPUT_PARAMSNUM_OUTPUT_PARAMS Int16Int16
NUM_RESULT_SETSNUM_RESULT_SETS Int16Int16
REMARKSREMARKS StringString
PROCEDURE_TYPEPROCEDURE_TYPE Int16Int16

ProcedureColumnsProcedureColumns

Nome colonnaColumnName Tipo di datiDataType
PROCEDURE_QUALIFIERPROCEDURE_QUALIFIER StringString
PROCEDURE_OWNERPROCEDURE_OWNER StringString
PROCEDURE_NAMEPROCEDURE_NAME StringString
COLUMN_NAMECOLUMN_NAME StringString
COLUMN_TYPECOLUMN_TYPE Int16Int16
DATA_TYPEDATA_TYPE Int16Int16
TYPE_NAMETYPE_NAME StringString
PRECISIONPRECISION Int32Int32
LENGTHLENGTH Int32Int32
SCALESCALE Int16Int16
RADIXRADIX Int16Int16
NULLABLENULLABLE Int16Int16
REMARKSREMARKS StringString
OVERLOADOVERLOAD Int32Int32
ORDINAL_POSITIONORDINAL_POSITION Int32Int32

Driver ODBC per Microsoft JetMicrosoft Jet ODBC Driver

Oltre alle raccolte di schemi comuni, il driver ODBC per Microsoft Jet supporta le raccolte di schemi specifici seguenti:The Microsoft Jet ODBC Driver supports the following specific schema collections in addition to the common schema collections:

  • TabelleTables

  • IndexesIndexes

  • ColonneColumns

  • ProcedureProcedures

  • ProcedureColumnsProcedureColumns

  • ProcedureParametersProcedureParameters

  • VisualizzazioniViews

Tables e ViewsTables and Views

Nome colonnaColumnName Tipo di datiDataType
TABLE_QUALIFIERTABLE_QUALIFIER StringString
TABLE_OWNERTABLE_OWNER StringString
TABLE_NAMETABLE_NAME StringString
TABLE_TYPETABLE_TYPE StringString
REMARKSREMARKS StringString

ColonneColumns

Nome colonnaColumnName Tipo di datiDataType
TABLE_QUALIFIERTABLE_QUALIFIER StringString
TABLE_OWNERTABLE_OWNER StringString
TABLE_NAMETABLE_NAME StringString
COLUMN_NAMECOLUMN_NAME StringString
DATA_TYPEDATA_TYPE Int16Int16
TYPE_NAMETYPE_NAME StringString
PRECISIONPRECISION Int32Int32
LENGTHLENGTH Int32Int32
SCALESCALE Int16Int16
RADIXRADIX Int16Int16
NULLABLENULLABLE Int16Int16
REMARKSREMARKS StringString
ORDINAL_POSITIONORDINAL_POSITION Int32Int32

ProcedureProcedures

Nome colonnaColumnName Tipo di datiDataType
PROCEDURE_QUALIFIERPROCEDURE_QUALIFIER StringString
PROCEDURE_OWNERPROCEDURE_OWNER StringString
PROCEDURE_NAMEPROCEDURE_NAME StringString
NUM_INPUT_PARAMSNUM_INPUT_PARAMS Int16Int16
NUM_OUTPUT_PARAMSNUM_OUTPUT_PARAMS Int16Int16
NUM_RESULT_SETSNUM_RESULT_SETS Int16Int16
REMARKSREMARKS StringString
PROCEDURE_TYPEPROCEDURE_TYPE Int16Int16

ProcedureColumnsProcedureColumns

Nome colonnaColumnName Tipo di datiDataType
PROCEDURE_QUALIFIERPROCEDURE_QUALIFIER StringString
PROCEDURE_OWNERPROCEDURE_OWNER StringString
PROCEDURE_NAMEPROCEDURE_NAME StringString
COLUMN_NAMECOLUMN_NAME StringString
COLUMN_TYPECOLUMN_TYPE Int16Int16
DATA_TYPEDATA_TYPE Int16Int16
TYPE_NAMETYPE_NAME StringString
PRECISIONPRECISION Int32Int32
LENGTHLENGTH Int32Int32
SCALESCALE Int16Int16
RADIXRADIX Int16Int16
NULLABLENULLABLE Int16Int16
REMARKSREMARKS StringString
OVERLOADOVERLOAD Int32Int32
ORDINAL_POSITIONORDINAL_POSITION Int32Int32

ProcedureParametersProcedureParameters

Nome colonnaColumnName Tipo di datiDataType
PROCEDURE_CATPROCEDURE_CAT StringString
PROCEDURE_SCHEMPROCEDURE_SCHEM StringString
PROCEDURE_NAMEPROCEDURE_NAME StringString
COLUMN_NAMECOLUMN_NAME StringString
COLUMN_TYPECOLUMN_TYPE Int16Int16
DATA_TYPEDATA_TYPE Int16Int16
TYPE_NAMETYPE_NAME StringString
COLUMN_SIZECOLUMN_SIZE Int32Int32
BUFFER_LENGTHBUFFER_LENGTH Int32Int32
DECIMAL_DIGITSDECIMAL_DIGITS Int16Int16
NUM_PREC_RADIXNUM_PREC_RADIX Int16Int16
NULLABLENULLABLE Int16Int16
REMARKSREMARKS StringString
COLUMN_DEFCOLUMN_DEF StringString
SQL_DATA_TYPESQL_DATA_TYPE Int16Int16
SQL_DATETIME_SUBSQL_DATETIME_SUB Int16Int16
CHAR_OCTET_LENGTHCHAR_OCTET_LENGTH Int32Int32
ORDINAL_POSITIONORDINAL_POSITION Int32Int32
IS_NULLABLEIS_NULLABLE StringaString

Vedere ancheSee Also

Provider gestiti ADO.NET e Centro per sviluppatori di set di datiADO.NET Managed Providers and DataSet Developer Center