Partager via

  • Article

Classe PartitionScheme

The PartitionScheme object provides programmatic access to partition schemes.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (dans Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute> _
Public NotInheritable Class PartitionScheme _
    Inherits ScriptNameObjectBase _
    Implements IDroppable, IAlterable, ICreatable, IScriptable
'Utilisation
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

Notes

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

Tout membre statique public (Partagé dans Microsoft Visual Basic) de ce type est sûr dans le cadre des opérations à plusieurs threads. Tous les membres de l'instance ne sont pas garantis comme sûrs.

Sécurité des threads

Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Il n'est pas garanti que les membres d'instance soient thread-safe.