다음을 통해 공유

  • 아티클

PartitionFunction 클래스

The PartitionFunction object provides programmatic access to partition functions.

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo.dll의 Microsoft.SqlServer.Smo

구문

‘선언
<PhysicalFacetAttribute> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
Public NotInheritable Class PartitionFunction _
    Inherits ScriptNameObjectBase _
    Implements IDroppable, IAlterable, ICreatable, IScriptable,  _
    IExtendedProperties
‘사용 방법
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

주의

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

이 유형의 모든 public static(Microsoft Visual Basic의 경우 공유) 멤버는 다중 스레드 작업을 수행하기에 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

스레드로부터의 안전성

이 형식의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.