Коллекции схем OLE DB (ADO.NET)
В данном разделе рассматривается поддержка коллекций схем для поставщиков OLE DB для Microsoft SQL Server, Oracle и Microsoft Jet.
Поставщик OLE DB для Microsoft SQL Server
Драйвер OLE DB для Microsoft SQL Server поддерживает следующие специальные коллекции схем в дополнение к общим коллекциям.
Tables
Columns
Procedures
ProcedureParameters
Catalog
Indexes
Tables
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 |
Columns
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 |
Procedures
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 |
Catalog
ColumnName |
DataType |
|---|---|
CATALOG_NAME |
String |
DESCRIPTION |
String |
Indexes
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 |
Поставщик Microsoft OLE DB для Oracle
Драйвер OLE DB для Oracle (Майкрософт) поддерживает следующие специальные коллекции схем в дополнение к общим коллекциям.
Tables
Columns
Procedures
ProcedureColumns
ProcedureParameters
Views
Indexes
Tables
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 |
Columns
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 |
Procedures
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 |
Views
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 |
Indexes
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 |
Поставщик OLE DB для Microsoft Jet
Драйвер OLE DB для Jet (Майкрософт) поддерживает следующие специальные коллекции схем в дополнение к общим коллекциям.
Tables
Columns
Procedures
Views
Indexes
Tables
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 |
Columns
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 |
Procedures
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 |
Views
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 |
Indexes
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 |