We recommend using Visual Studio 2017

Index.Script Method

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

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

public StringCollection Script()

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.