Share via

SqlDataDictionary.indexDrop Method

  • Reference

Definition

Namespace:
Dynamics.AX.Application
Assembly:
Microsoft.Dynamics.AX.Xpp.Support.dll

Overloads

indexDrop(Int32, Int32, Boolean)
indexDrop(Int32, Int32)
indexDrop(Int32)
indexDrop()

Drops the indexes of a table in the SQL database.

indexDrop(Int32, Int32, Boolean) 

public:
 virtual int indexDrop(int _tableId, int _indexId, bool _onlyNonUnique);
public virtual int indexDrop (int _tableId, int _indexId, bool _onlyNonUnique);
abstract member indexDrop : int * int * bool -> int
override this.indexDrop : int * int * bool -> int
Public Overridable Function indexDrop (_tableId As Integer, _indexId As Integer, _onlyNonUnique As Boolean) As Integer

Parameters

_tableId
Int32
_indexId
Int32
_onlyNonUnique
Boolean

Returns

Int32

Applies to

indexDrop(Int32, Int32) 

public:
 virtual int indexDrop(int num1, int num2);
public virtual int indexDrop (int num1, int num2);
abstract member indexDrop : int * int -> int
override this.indexDrop : int * int -> int
Public Overridable Function indexDrop (num1 As Integer, num2 As Integer) As Integer

Parameters

num1
Int32
num2
Int32

Returns

Int32

Applies to

indexDrop(Int32) 

public:
 virtual int indexDrop(int num1);
public virtual int indexDrop (int num1);
abstract member indexDrop : int -> int
override this.indexDrop : int -> int
Public Overridable Function indexDrop (num1 As Integer) As Integer

Parameters

num1
Int32

Returns

Int32

Applies to

indexDrop()

Drops the indexes of a table in the SQL database.

public:
 virtual int indexDrop();
public virtual int indexDrop ();
abstract member indexDrop : unit -> int
override this.indexDrop : unit -> int
Public Overridable Function indexDrop () As Integer

Returns

Int32

Zero if the method succeeds.

Remarks

Use 0 for the parameters to indicate all tables or indexes.

The following example demonstrates the indexDrop method.

{ 
    SqlDataDictionary DD = new SqlDataDictionary(); 
    DD.indexDrop(TableName2Id("Address")); 
}

Applies to