Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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


Type: Microsoft.SqlServer.Management.Smo.ScriptingOptions

A ScriptingOptions object value that is used to specify the script options.

Return Value

Type: System.Collections.Specialized.StringCollection

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

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


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

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft