Metodo Index.Script (ScriptingOptions)

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

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public Function Script ( _
    scriptingOptions As ScriptingOptions _
) As StringCollection
'Utilizzo
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

Parametri

Valore restituito

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)

Osservazioni

Lo script generato potrebbe contenere procedure interne non documentate, necessarie per generare l'output completo dello script.

[!NOTA]

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

Esempi

Generazione di script

Vedere anche

Riferimento

Index Classe

Overload Script

Spazio dei nomi Microsoft.SqlServer.Management.Smo

Altre risorse

Indici

ALTER INDEX (Transact-SQL)