Condividi tramite

  • Articolo

Classe PartitionFunction

The PartitionFunction object provides programmatic access to partition functions.

Spazio dei nomi:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<PhysicalFacetAttribute> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
Public NotInheritable Class PartitionFunction _
    Inherits ScriptNameObjectBase _
    Implements IDroppable, IAlterable, ICreatable, IScriptable,  _
    IExtendedProperties
'Utilizzo
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

Osservazioni

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

Tutti i membri statici pubblici (Shared in Microsoft Visual Basic) di questo tipo sono sicuri per le operazioni a thread multipli. Non è invece garantita la sicurezza dei membri dell'istanza.

Thread Safety

Tutti i membri pubblici static (Shared in Visual Basic) di questo tipo sono thread safe. I membri di istanza non hanno garanzia di essere thread safe.