Partilhar via


Método Index.Script (ScriptingOptions)

Generates a Transact-SQL script that can be used to re-create the index as specified by the script options.

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

Sintaxe

'Declaração
Public Function Script ( _
    scriptingOptions As ScriptingOptions _
) As StringCollection
'Uso
Dim instance As Index 
Dim scriptingOptions As ScriptingOptions 
Dim returnValue As StringCollection 

returnValue = instance.Script(scriptingOptions)
public StringCollection Script(
    ScriptingOptions scriptingOptions
)
public:
virtual StringCollection^ Script(
    ScriptingOptions^ scriptingOptions
) sealed
abstract Script : 
        scriptingOptions:ScriptingOptions -> StringCollection  
override Script : 
        scriptingOptions:ScriptingOptions -> StringCollection
public final function Script(
    scriptingOptions : ScriptingOptions
) : StringCollection

Parâmetros

Valor de retorno

Tipo: System.Collections.Specialized.StringCollection
A StringCollection system object value that contains a list of Transact-SQL statements in the script.

Implementa

IScriptable.Script(ScriptingOptions)

Comentários

O script gerado pode conter procedimentos internos não documentados, necessários à saída do script completo.

ObservaçãoObservação

Indexes based partly on the UserDefinedTableType object do not support this method and running this method will generate an exception.

Exemplos

Gerando scripts

Consulte também

Referência

Index Classe

Sobrecarregado Script

Namespace Microsoft.SqlServer.Management.Smo

Outros recursos

Índices

ALTER INDEX (Transact-SQL)