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