OLE DB 架构集合
本节讨论对适用于 Microsoft SQL Server、Oracle 和 Microsoft Jet 的 OLE DB 提供程序的架构集合支持
Microsoft SQL Server OLE DB 提供程序
除了通用架构集合之外，Microsoft SQL Server OLE DB 驱动程序还支持下列特定的架构集合：
表
列
过程
ProcedureParameters
目录
索引
表
| ColumnName | 数据类型 |
|---|---|
| TABLE_CATALOG | 字符串 |
| TABLE_SCHEMA | 字符串 |
| TABLE_NAME | 字符串 |
| TABLE_TYPE | 字符串 |
| TABLE_GUID | Guid |
| DESCRIPTION | String |
| TABLE_PROPID | Int64 |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
列
| ColumnName | 数据类型 |
|---|---|
| TABLE_CATALOG | 字符串 |
| TABLE_SCHEMA | 字符串 |
| TABLE_NAME | 字符串 |
| COLUMN_NAME | 字符串 |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| ORDINAL_POSITION | Int64 |
| COLUMN_HASDEFAULT | 布尔 |
| COLUMN_DEFAULT | 字符串 |
| COLUMN_FLAGS | Int64 |
| IS_NULLABLE | 布尔 |
| 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 | 字符串 |
| CHARACTER_SET_SCHEMA | 字符串 |
| CHARACTER_SET_NAME | 字符串 |
| COLLATION_CATALOG | 字符串 |
| COLLATION_SCHEMA | 字符串 |
| COLLATION_NAME | 字符串 |
| 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 | 布尔 |
过程
| ColumnName | 数据类型 |
|---|---|
| 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 | 数据类型 |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PARAMETER_NAME | 字符串 |
| ORDINAL_POSITION | Int32 |
| PARAMETER_TYPE | Int32 |
| PARAMETER_HASDEFAULT | 布尔 |
| PARAMETER_DEFAULT | String |
| IS_NULLABLE | 布尔 |
| 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 |
目录
| ColumnName | 数据类型 |
|---|---|
| CATALOG_NAME | String |
| DESCRIPTION | String |
索引
| ColumnName | 数据类型 |
|---|---|
| TABLE_CATALOG | 字符串 |
| TABLE_SCHEMA | 字符串 |
| TABLE_NAME | 字符串 |
| INDEX_CATALOG | String |
| INDEX_SCHEMA | String |
| INDEX_NAME | String |
| PRIMARY_KEY | 布尔 |
| UNIQUE | 布尔 |
| CLUSTERED | 布尔 |
| TYPE | Int32 |
| FILL_FACTOR | Int32 |
| INITIAL_SIZE | Int32 |
| NULLS | Int32 |
| SORT_BOOKMARKS | 布尔 |
| AUTO_UPDATE | 布尔 |
| NULL_COLLATION | Int32 |
| ORDINAL_POSITION | Int64 |
| COLUMN_NAME | 字符串 |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| COLLATION | Int16 |
| CARDINALITY | 小数 |
| PAGES | Int32 |
| FILTER_CONDITION | String |
| INTEGRATED | 布尔 |
Microsoft Oracle OLE DB 提供程序
除了通用架构集合之外，Microsoft Oracle OLE DB 驱动程序还支持下列特定的架构集合：
表
列
过程
ProcedureColumns
ProcedureParameters
视图
索引
表
| ColumnName | 数据类型 |
|---|---|
| TABLE_CATALOG | 字符串 |
| TABLE_SCHEMA | 字符串 |
| TABLE_NAME | 字符串 |
| TABLE_TYPE | 字符串 |
| TABLE_GUID | Guid |
| DESCRIPTION | String |
| TABLE_PROPID | Int64 |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
列
| ColumnName | 数据类型 |
|---|---|
| TABLE_CATALOG | 字符串 |
| TABLE_SCHEMA | 字符串 |
| TABLE_NAME | 字符串 |
| COLUMN_NAME | 字符串 |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| ORDINAL_POSITION | Int64 |
| COLUMN_HASDEFAULT | 布尔 |
| COLUMN_DEFAULT | 字符串 |
| COLUMN_FLAGS | Int64 |
| IS_NULLABLE | 布尔 |
| 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 | 字符串 |
| CHARACTER_SET_SCHEMA | 字符串 |
| CHARACTER_SET_NAME | 字符串 |
| COLLATION_CATALOG | 字符串 |
| COLLATION_SCHEMA | 字符串 |
| COLLATION_NAME | 字符串 |
| DOMAIN_CATALOG | String |
| DOMAIN_SCHEMA | String |
| DOMAIN_NAME | String |
| DESCRIPTION | String |
过程
| ColumnName | 数据类型 |
|---|---|
| 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 | 数据类型 |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| COLUMN_NAME | 字符串 |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| ROWSET_NUMBER | Int64 |
| ORDINAL_POSITION | Int64 |
| IS_NULLABLE | 布尔 |
| DATA_TYPE | Int32 |
| TYPE_GUID | Guid |
| CHARACTER_MAXIMUM_LENGTH | Int64 |
| CHARACTER_OCTET_LENGTH | Int64 |
| NUMERIC_PRECISION | Int32 |
| NUMERIC_SCALE | Int16 |
| DESCRIPTION | String |
| OVERLOAD | Int16 |
视图
| ColumnName | 数据类型 |
|---|---|
| TABLE_CATALOG | 字符串 |
| TABLE_SCHEMA | 字符串 |
| TABLE_NAME | 字符串 |
| VIEW_DEFINITION | String |
| CHECK_OPTION | 布尔 |
| IS_UPDATABLE | 布尔 |
| DESCRIPTION | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
索引
| ColumnName | 数据类型 |
|---|---|
| TABLE_CATALOG | 字符串 |
| TABLE_SCHEMA | 字符串 |
| TABLE_NAME | 字符串 |
| INDEX_CATALOG | String |
| INDEX_SCHEMA | String |
| INDEX_NAME | String |
| PRIMARY_KEY | 布尔 |
| UNIQUE | 布尔 |
| CLUSTERED | 布尔 |
| TYPE | Int32 |
| FILL_FACTOR | Int32 |
| INITIAL_SIZE | Int32 |
| NULLS | Int32 |
| SORT_BOOKMARKS | 布尔 |
| AUTO_UPDATE | 布尔 |
| NULL_COLLATION | Int32 |
| ORDINAL_POSITION | Int64 |
| COLUMN_NAME | 字符串 |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| COLLATION | Int16 |
| CARDINALITY | 小数 |
| PAGES | Int32 |
| FILTER_CONDITION | String |
| INTEGRATED | 布尔 |
Microsoft Jet OLE DB
除了通用架构集合之外，Microsoft Jet OLE DB 驱动程序还支持下列特定的架构集合：
表
列
过程
视图
索引
表
| ColumnName | 数据类型 |
|---|---|
| TABLE_CATALOG | 字符串 |
| TABLE_SCHEMA | 字符串 |
| TABLE_NAME | 字符串 |
| TABLE_TYPE | 字符串 |
| TABLE_GUID | Guid |
| DESCRIPTION | String |
| TABLE_PROPID | Int64 |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
列
| ColumnName | 数据类型 |
|---|---|
| TABLE_CATALOG | 字符串 |
| TABLE_SCHEMA | 字符串 |
| TABLE_NAME | 字符串 |
| COLUMN_NAME | 字符串 |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| ORDINAL_POSITION | Int64 |
| COLUMN_HASDEFAULT | 布尔 |
| COLUMN_DEFAULT | 字符串 |
| COLUMN_FLAGS | Int64 |
| IS_NULLABLE | 布尔 |
| 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 | 字符串 |
| CHARACTER_SET_SCHEMA | 字符串 |
| CHARACTER_SET_NAME | 字符串 |
| COLLATION_CATALOG | 字符串 |
| COLLATION_SCHEMA | 字符串 |
| COLLATION_NAME | 字符串 |
| DOMAIN_CATALOG | String |
| DOMAIN_SCHEMA | String |
| DOMAIN_NAME | String |
| DESCRIPTION | String |
过程
| ColumnName | 数据类型 |
|---|---|
| PROCEDURE_CATALOG | String |
| PROCEDURE_SCHEMA | String |
| PROCEDURE_NAME | String |
| PROCEDURE_TYPE | Int16 |
| PROCEDURE_DEFINITION | String |
| DESCRIPTION | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
视图
| ColumnName | 数据类型 |
|---|---|
| TABLE_CATALOG | 字符串 |
| TABLE_SCHEMA | 字符串 |
| TABLE_NAME | 字符串 |
| VIEW_DEFINITION | String |
| CHECK_OPTION | 布尔 |
| IS_UPDATABLE | 布尔 |
| DESCRIPTION | String |
| DATE_CREATED | DateTime |
| DATE_MODIFIED | DateTime |
索引
| ColumnName | 数据类型 |
|---|---|
| TABLE_CATALOG | 字符串 |
| TABLE_SCHEMA | 字符串 |
| TABLE_NAME | 字符串 |
| INDEX_CATALOG | String |
| INDEX_SCHEMA | String |
| INDEX_NAME | String |
| PRIMARY_KEY | 布尔 |
| UNIQUE | 布尔 |
| CLUSTERED | 布尔 |
| TYPE | Int32 |
| FILL_FACTOR | Int32 |
| INITIAL_SIZE | Int32 |
| NULLS | Int32 |
| SORT_BOOKMARKS | 布尔 |
| AUTO_UPDATE | 布尔 |
| NULL_COLLATION | Int32 |
| ORDINAL_POSITION | Int64 |
| COLUMN_NAME | 字符串 |
| COLUMN_GUID | Guid |
| COLUMN_PROPID | Int64 |
| COLLATION | Int16 |
| CARDINALITY | 小数 |
| PAGES | Int32 |
| FILTER_CONDITION | String |
| INTEGRATED | 布尔 |