Freigeben über

  • Artikel

PartitionFunction-Klasse

The PartitionFunction object provides programmatic access to partition functions.

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

Syntax

'Declaration
<PhysicalFacetAttribute> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
Public NotInheritable Class PartitionFunction _
    Inherits ScriptNameObjectBase _
    Implements IDroppable, IAlterable, ICreatable, IScriptable,  _
    IExtendedProperties
'Usage
Dim instance As PartitionFunction

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

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

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

public final class PartitionFunction extends ScriptNameObjectBase implements IDroppable, IAlterable, ICreatable, IScriptable, IExtendedProperties

Hinweise

Partition functions are used to partition tables and indexes across multiple file groups.

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

To set PartitionFunction 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 function, users must have 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 merge or split the range values on the partition function, users must have 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

Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Für Instanzelemente kann nicht sichergestellt werden, dass sie für Threads sicher sind.

Threadsicherheit

Alle öffentlichen static (Shared in Visual Basic) Member dieses Typs sind threadsicher. Bei Instanzmembern ist die Threadsicherheit nicht gewährleistet.