Método Enable

Enables the index.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
Public Sub Enable ( _
    action As IndexEnableAction _
)
'Uso
Dim instance As Index
Dim action As IndexEnableAction

instance.Enable(action)

public void Enable(
    IndexEnableAction action
)

public:
void Enable(
    IndexEnableAction action
)

member Enable : 
        action:IndexEnableAction -> unit 

public function Enable(
    action : IndexEnableAction
)

Parâmetros

• action
  Tipo: Microsoft.SqlServer.Management.Smo. . :: . .IndexEnableAction
  An IndexEnableAction object value that specifies the action to take when enabling the index.

Comentários

The action parameter is used to specify actions such as rebuild or re-create the index.

Observação
Indexes based on the UserDefinedTableType object cannot be modified and running this method will generate an exception.

Exemplos

Criando, alterando e removendo índices

Consulte também

Referência

Index Classe

Membros Index

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

Índices

DROP INDEX (Transact-SQL)