Index.Script Method

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

備註

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

PAD_INDEX

ALLOW_PAGE_LOCKS

ALLOW_ROW_LOCKS

ONLINE

只有 Microsoft .NET Framework 2.0 版支援此命名空間、類別或成員。

多載清單

名稱 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.

請參閱

參考

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

其他資源

Scripting
索引
ALTER INDEX (Transact-SQL)