Rebuild Method

SQLServer.Database.Table.Index Object

Description

Drops and re-creates the index.

Visual Basic

Index.Rebuild

C++

HRESULT pIndex->Rebuild ( );

Remarks

If you need to redefine an Index (for example, change the fill factor or add a column), then you must first Remove the Index, then Add a new one.