OleDbSchemaGuid.Indexes Field

 

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

Namespace:   System.Data.OleDb
Assembly:  System.Data (in System.Data.dll)

public static readonly Guid Indexes

Field Value

Type: System.Guid

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.

.NET Framework
Available since 1.1
Return to top
Show: