Partager via

  • Article

Classe FileGroup

The FileGroup object represents a SQL Server file group.

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

Syntaxe

'Déclaration
<PhysicalFacetAttribute> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
Public NotInheritable Class FileGroup _
    Inherits NamedSmoObject _
    Implements ICreatable, IAlterable, IDroppable, IRenamable,  _
    IMarkForDrop
'Utilisation
Dim instance As FileGroup

[PhysicalFacetAttribute]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
public sealed class FileGroup : NamedSmoObject, 
    ICreatable, IAlterable, IDroppable, IRenamable, IMarkForDrop

[PhysicalFacetAttribute]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
public ref class FileGroup sealed : public NamedSmoObject, 
    ICreatable, IAlterable, IDroppable, IRenamable, IMarkForDrop

[<SealedAttribute>]
[<PhysicalFacetAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
type FileGroup =  
    class
        inherit NamedSmoObject
        interface ICreatable
        interface IAlterable
        interface IDroppable
        interface IRenamable
        interface IMarkForDrop
    end

public final class FileGroup extends NamedSmoObject implements ICreatable, IAlterable, IDroppable, IRenamable, IMarkForDrop

Notes

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

To set FileGroup object properties, users must have ALTER permission on the database or be a member of the db_owner fixed database role.

To create a file group, users must have ALTER permission on the database or be a member of the db_owner fixed database role.

To drop a file group, users must have ALTER permission on the database or be a member of the db_owner fixed database role.

To run CheckFileGroup and CheckFileGroupDataOnly methods, users must be a member of the db_owner fixed database role or the 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.