通过

OLE DB 架构集合 (ADO.NET)

  • 项目

更新：November 2007

本节讨论对适用于 Microsoft SQL Server、Oracle 和 Microsoft Jet 的 OLE DB 提供程序的架构集合支持。

Microsoft SQL Server OLE DB 提供程序

除了通用架构集合之外，Microsoft SQL Server OLE DB 驱动程序还支持下列特定的架构集合：

  • Tables

  • Columns

  • Procedures

  • ProcedureParameters

  • Catalog

  • Indexes

Tables

列名

数据类型

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

列名

数据类型

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

列名

数据类型

PROCEDURE_CATALOG

String

PROCEDURE_SCHEMA

String

PROCEDURE_NAME

String

PROCEDURE_TYPE

Int16

PROCEDURE_DEFINITION

String

DESCRIPTION

String

DATE_CREATED

DateTime

DATE_MODIFIED

DateTime

ProcedureParameters

列名

数据类型

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

列名

数据类型

CATALOG_NAME

String

DESCRIPTION

String

Indexes

列名

数据类型

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 Oracle OLE DB 提供程序

除了通用架构集合之外，Microsoft Oracle OLE DB 驱动程序还支持下列特定的架构集合：

  • Tables

  • Columns

  • Procedures

  • ProcedureColumns

  • ProcedureParameters

  • Views

  • Indexes

Tables

列名

数据类型

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

列名

数据类型

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

列名

数据类型

PROCEDURE_CATALOG

String

PROCEDURE_SCHEMA

String

PROCEDURE_NAME

String

PROCEDURE_TYPE

Int16

PROCEDURE_DEFINITION

String

DESCRIPTION

String

DATE_CREATED

DateTime

DATE_MODIFIED

DateTime

ProcedureColumns

列名

数据类型

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

列名

数据类型

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

列名

数据类型

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 Jet OLE DB 提供程序

除了通用架构集合之外，Microsoft Jet OLE DB 驱动程序还支持下列特定的架构集合：

  • Tables

  • Columns

  • Procedures

  • Views

  • Indexes

Tables

列名

数据类型

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

列名

数据类型

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

列名

数据类型

PROCEDURE_CATALOG

String

PROCEDURE_SCHEMA

String

PROCEDURE_NAME

String

PROCEDURE_TYPE

Int16

PROCEDURE_DEFINITION

String

DESCRIPTION

String

DATE_CREATED

DateTime

DATE_MODIFIED

DateTime

Views

列名

数据类型

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

列名

数据类型

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