PartitionFunction Class
The PartitionFunction object provides programmatic access to partition functions.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Bildirim
<PhysicalFacetAttribute> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
Public NotInheritable Class PartitionFunction
Inherits ScriptNameObjectBase
Implements IDroppable, IAlterable, ICreatable, IScriptable, _
IExtendedProperties
[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
/** @attribute PhysicalFacetAttribute() */
/** @attribute EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule) */
public final class PartitionFunction extends ScriptNameObjectBase implements IDroppable, IAlterable,
ICreatable, IScriptable, IExtendedProperties
PhysicalFacetAttribute
EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)
public final class PartitionFunction extends ScriptNameObjectBase implements IDroppable, IAlterable,
ICreatable, IScriptable, IExtendedProperties
Remarks
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.
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.NamedSmoObject
Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase
Microsoft.SqlServer.Management.Smo.PartitionFunction
Thread Safety
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.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
See Also