Index.DisallowPageLocks Property

Gets or sets the Boolean property value that specifies whether the index allows page locks.

命名空间: Microsoft.SqlServer.Management.Smo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public Property DisallowPageLocks As Boolean
public bool DisallowPageLocks { get; set; }
public:
property bool DisallowPageLocks {
    bool get ();
    void set (bool value);
}
/** @property */
public boolean get_DisallowPageLocks ()

/** @property */
public void set_DisallowPageLocks (boolean value)
public function get DisallowPageLocks () : boolean

public function set DisallowPageLocks (value : boolean)

属性值

A Boolean value that specifies the whether the index allows page locks or not. If True, page locks are not allowed on the index. If False (default), page locks are allowed on the index.

备注

When this property is True, page locks are not used. Access to the specified index is obtained with row-level and table-level locks.

仅 Microsoft .NET Framework 的 2.0 版本支持此命名空间、类或成员。

示例

How to: Create a Non-Clustered, Composite Index in Visual Basic .NET

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

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

其他资源

Creating, Altering, and Removing Indexes
索引
CREATE INDEX (Transact-SQL)