Raccolte di schemi OLE DB (ADO.NET)
In questa sezione viene descritto il supporto delle raccolte di schemi per i provider OLE DB per Microsoft SQL Server, Oracle e Microsoft Jet.
Provider OLE DB per Microsoft SQL Server
Oltre alle raccolte di schemi comuni, il driver OLE DB di Microsoft SQL Server supporta le raccolte di schemi specifici seguenti:
Tables
Columns
Procedures
ProcedureParameters
Catalog
Indexes
Tables
Nome colonna |
Tipo di dati |
|---|---|
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 |
Columns
Nome colonna |
Tipo di dati |
|---|---|
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 |
Procedures
Nome colonna |
Tipo di dati |
|---|---|
PROCEDURE_CATALOG |
String |
PROCEDURE_SCHEMA |
String |
PROCEDURE_NAME |
String |
PROCEDURE_TYPE |
Int16 |
PROCEDURE_DEFINITION |
String |
DESCRIPTION |
String |
DATE_CREATED |
DateTime |
DATE_MODIFIED |
DateTime |
ProcedureParameters
Nome colonna |
Tipo di dati |
|---|---|
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 |
Catalog
Nome colonna |
Tipo di dati |
|---|---|
CATALOG_NAME |
String |
DESCRIPTION |
String |
Indexes
Nome colonna |
Tipo di dati |
|---|---|
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 |
Provider OLE DB per Microsoft Oracle
Oltre alle raccolte di schemi comuni, il driver OLE DB per Microsoft Oracle supporta le seguenti raccolte di schemi specifici:
Tabelle
Colonne
Procedures
ProcedureColumns
ProcedureParameters
Views
Indexes
Tables
Nome colonna |
Tipo di dati |
|---|---|
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 |
Columns
Nome colonna |
Tipo di dati |
|---|---|
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 |
Procedures
Nome colonna |
Tipo di dati |
|---|---|
PROCEDURE_CATALOG |
String |
PROCEDURE_SCHEMA |
String |
PROCEDURE_NAME |
String |
PROCEDURE_TYPE |
Int16 |
PROCEDURE_DEFINITION |
String |
DESCRIPTION |
String |
DATE_CREATED |
DateTime |
DATE_MODIFIED |
DateTime |
ProcedureColumns
Nome colonna |
Tipo di dati |
|---|---|
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 |
Views
Nome colonna |
Tipo di dati |
|---|---|
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 |
Indexes
Nome colonna |
Tipo di dati |
|---|---|
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 |
Provider OLE DB per Microsoft Jet
Oltre alle raccolte di schemi comuni, il driver OLE DB di Microsoft Jet supporta le raccolte di schemi specifici seguenti:
Tables
Columns
Procedures
Views
Indexes
Tables
Nome colonna |
Tipo di dati |
|---|---|
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 |
Columns
Nome colonna |
Tipo di dati |
|---|---|
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 |
Procedures
Nome colonna |
Tipo di dati |
|---|---|
PROCEDURE_CATALOG |
String |
PROCEDURE_SCHEMA |
String |
PROCEDURE_NAME |
String |
PROCEDURE_TYPE |
Int16 |
PROCEDURE_DEFINITION |
String |
DESCRIPTION |
String |
DATE_CREATED |
DateTime |
DATE_MODIFIED |
DateTime |
Views
Nome colonna |
Tipo di dati |
|---|---|
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 |
Indexes
Nome colonna |
Tipo di dati |
|---|---|
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 |