Partilhar via


Index.Script Method

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

Remarks

The following options do not appear in the script for the Index object:

PAD_INDEX

ALLOW_PAGE_LOCKS

ALLOW_ROW_LOCKS

ONLINE

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Overload List

Name Description
Index.Script ()
Generates a Transact-SQL script that can be used to re-create the index.
Index.Script (ScriptingOptions)
Generates a Transact-SQL script that can be used to re-create the index as specified by the script options.

See Also

Reference

Index Class
Index Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Scripting
Indexes
ALTER INDEX (Transact-SQL)