Compartilhar via

  • Artigo

Classe FileGroup

The FileGroup object represents a SQL Server file group.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)

Sintaxe

'Declaração
<PhysicalFacetAttribute> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
Public NotInheritable Class FileGroup _
    Inherits NamedSmoObject _
    Implements ICreatable, IAlterable, IDroppable, IRenamable,  _
    IMarkForDrop
'Uso
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

Comentários

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

Qualquer membro público estático (Compartilhado no Microsoft Visual Basic) desse tipo é seguro para operações multi-threaded. Não há garantia de que qualquer membro de instância seja seguro para threads.

Segurança de thread

Quaisquer membros static (Shared no Visual Basic) públicos deste tipo são thread-safe. Não há garantia de que qualquer membro de instância seja thread-safe.