Export (0) Print
Expand All

Index.Script Method (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 (in Microsoft.SqlServer.Smo.dll)

public StringCollection Script(
	ScriptingOptions scriptingOptions
)

Parameters

scriptingOptions
Type: Microsoft.SqlServer.Management.Smo.ScriptingOptions
A ScriptingOptions object value that is used to specify the script options.

Return Value

Type: StringCollection
A StringCollection system object value that contains a list of Transact-SQL statements in the script.

Implements

IScriptable.Script(ScriptingOptions)

The generated script might contain undocumented, internal procedures, which are required for the complete script output.

NoteNote

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft