Share via

  • 發行項

PartitionScheme 類別

The PartitionScheme object provides programmatic access to partition schemes.

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute> _
Public NotInheritable Class PartitionScheme _
    Inherits ScriptNameObjectBase _
    Implements IDroppable, IAlterable, ICreatable, IScriptable
'用途
Dim instance As PartitionScheme

[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute]
public sealed class PartitionScheme : ScriptNameObjectBase, 
    IDroppable, IAlterable, ICreatable, IScriptable

[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute]
public ref class PartitionScheme sealed : public ScriptNameObjectBase, 
    IDroppable, IAlterable, ICreatable, IScriptable

[<SealedAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute>]
type PartitionScheme =  
    class
        inherit ScriptNameObjectBase
        interface IDroppable
        interface IAlterable
        interface ICreatable
        interface IScriptable
    end

public final class PartitionScheme extends ScriptNameObjectBase implements IDroppable, IAlterable, ICreatable, IScriptable

備註

Partition schemes define the physical structure that is used to partition tables and indexes across multiple file groups.

To get PartitionScheme object properties, users can be a member of the public fixed server role.

To set PartitionScheme object propertied, users must ALTER permission on the database or ALTER ANY DATASPACE permission on the server or be a member of the db_owner or db_ddladmin fixed database roles or a member of sysadmin fixed server role.

To create or drop a partition scheme, users must ALTER permission on the database or ALTER ANY DATASPACE permission on the server or be a member of the db_owner or db_ddladmin fixed database roles or a member of sysadmin fixed server role.

Thread Safety

這種類型的任何公用靜態 (在 Microsoft Visual Basic 中則為 Shared) 成員都可用於多執行緒作業。並不是所有的執行個體成員都保證可以用於所有的執行緒。

執行緒安全性

這個類型的任何公用static (在 Visual Basic 中為 Shared) 成員都是安全執行緒。不保證任何執行個體成員都可以是安全執行緒。