OleDbSchemaGuid.Indexes Field

Definition

Returns the indexes defined in the catalog that is owned by a given user.

public: static initonly Guid Indexes;
public static readonly Guid Indexes;
 staticval mutable Indexes : Guid
Public Shared ReadOnly Indexes As Guid 

Field Value

Remarks

Indexes maps to the OLE DB INDEXES rowset. Unless otherwise specified, restriction columns are returned in the following order.

Restriction column CLR data type Description
TABLE_CATALOG string Catalog name. A null value if the provider does not support catalogs.
TABLE_SCHEMA string Unqualified schema name. A null value if the provider does not support schemas.
INDEX_NAME string Index name.
TYPE UInt16 (Int32) The type of the index. One of the following:

DBPROPVAL_IT_BTREE-The index is a B+-tree.

DBPROPVAL_IT_HASH-The index is a hash file using, for example, linear or extensible hashing.

DBPROPVAL_IT_CONTENT-The index is a content index.

DBPROPVAL_IT_OTHER-The index is some other type of index.
TABLE_NAME string Table name.

Applies to