Classe FileGroup
The FileGroup object represents a SQL Server file group. For more information about file groups, see Utilisation de fichiers ou de groupes de fichiers pour stocker des données.
Hiérarchie d'héritage
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.NamedSmoObject
Microsoft.SqlServer.Management.Smo.FileGroup
Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Syntaxe
'Déclaration
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<PhysicalFacetAttribute> _
Public NotInheritable Class FileGroup _
Inherits NamedSmoObject _
Implements ICreatable, IAlterable, IDroppable, IRenamable, _
IMarkForDrop, ISfcSupportsDesignMode
'Utilisation
Dim instance As FileGroup
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[PhysicalFacetAttribute]
public sealed class FileGroup : NamedSmoObject,
ICreatable, IAlterable, IDroppable, IRenamable, IMarkForDrop,
ISfcSupportsDesignMode
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[PhysicalFacetAttribute]
public ref class FileGroup sealed : public NamedSmoObject,
ICreatable, IAlterable, IDroppable, IRenamable, IMarkForDrop,
ISfcSupportsDesignMode
[<SealedAttribute>]
[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<PhysicalFacetAttribute>]
type FileGroup =
class
inherit NamedSmoObject
interface ICreatable
interface IAlterable
interface IDroppable
interface IRenamable
interface IMarkForDrop
interface ISfcSupportsDesignMode
end
public final class FileGroup extends NamedSmoObject implements ICreatable, IAlterable, IDroppable, IRenamable, IMarkForDrop, ISfcSupportsDesignMode
Le type FileGroup expose les membres suivants.
Constructeurs
Nom | Description | |
---|---|---|
![]() |
FileGroup() | Initializes a new instance of the FileGroup class. |
![]() |
FileGroup(Database, String) | Initializes a new instance of the FileGroup class on the specified database that has the specified name. |
![]() |
FileGroup(Database, String, Boolean) | Initializes a new instance of the FileGroup class on the specified database with the specified name. Optionally, enables a FILESTREAM file group to be created. |
Haut de la page
Propriétés
Nom | Description | |
---|---|---|
![]() |
Files | Represents a collection of DataFile objects. Each DataFile object represents a file belonging to the file group. |
![]() |
ID | Gets the ID value that uniquely identifies the file group. |
![]() |
IsDefault | Gets or sets the Boolean value that specifies whether the file group is the default file group for the database. |
![]() |
IsFileStream | Gets the Boolean value that specifies whether the file group is of type FILESTREAM. |
![]() |
Name | Gets or sets the name of the object. (hérité de NamedSmoObject.) |
![]() |
Parent | Gets or sets the parent Database object of the FileGroup object. |
![]() |
Properties | Gets a collection of Property objects that represent the object properties. (hérité de SqlSmoObject.) |
![]() |
ReadOnly | Gets the Boolean value that specifies whether the file group is read-only. |
![]() |
Size | Gets or sets the size of the file group in KB. |
![]() |
State | Gets the state of the referenced object. (hérité de SmoObjectBase.) |
![]() |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (hérité de SqlSmoObject.) |
![]() |
UserData | Gets or sets user-defined data associated with the referenced object. (hérité de SmoObjectBase.) |
Haut de la page
Méthodes
Nom | Description | |
---|---|---|
![]() |
Alter | Updates any property changes to the FileGroup object on the instance of SQL Server. |
![]() |
CheckFileGroup | Scans and tests the integrity of database pages maintained in operating system files that implement the file group. |
![]() |
CheckFileGroupDataOnly | Scans and tests the integrity of database pages that are used to maintain table data in operating system files that implement the file group. |
![]() |
Create | Creates a new file group based on the FileGroup object. |
![]() |
Discover | Discovers a list of type Object. (hérité de SqlSmoObject.) |
![]() |
Drop | Drops the file group from the database. |
![]() |
EnumObjects | Enumerates the system and user-defined tables, indexes, and statistics mechanisms stored within a file group. |
![]() |
Equals | (hérité de Object.) |
![]() |
FormatSqlVariant | Formats an object as SqlVariant type. (hérité de SqlSmoObject.) |
![]() |
GetContextDB | Gets the context database that is associated with this object. (hérité de SqlSmoObject.) |
![]() |
GetDBName | Gets the database name that is associated with the object. (hérité de SqlSmoObject.) |
![]() |
GetHashCode | (hérité de Object.) |
![]() |
GetPropValue | Gets a property value of the SqlSmoObject object. (hérité de SqlSmoObject.) |
![]() |
GetPropValueOptional | Gets a property value of the SqlSmoObject object. (hérité de SqlSmoObject.) |
![]() |
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (hérité de SqlSmoObject.) |
![]() |
GetServerObject | Gets the server of the SqlSmoObject object. (hérité de SqlSmoObject.) |
![]() |
GetType | (hérité de Object.) |
![]() |
Initialize() | Initializes the object and forces the properties be loaded. (hérité de SqlSmoObject.) |
![]() |
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (hérité de SqlSmoObject.) |
![]() |
IsObjectInitialized | Verifies whether the object has been initialized. (hérité de SqlSmoObject.) |
![]() |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (hérité de SqlSmoObject.) |
![]() |
MarkForDrop | Marks the file group to be dropped next time its parent Database object is altered by the Alter method. |
![]() |
Refresh | Refreshes the object and retrieves properties when the object is next accessed. (hérité de SqlSmoObject.) |
![]() |
Rename | Renames the file group. |
![]() |
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (hérité de SqlSmoObject.) |
![]() |
ToString | Returns a String that represents the referenced object. (hérité de SqlSmoObject.) |
![]() |
Validate | Validates the state of an object. (hérité de SmoObjectBase.) |
Haut de la page
Événements
Nom | Description | |
---|---|---|
![]() |
PropertyChanged | Represents the event that occurs when a property is changed. (hérité de SqlSmoObject.) |
![]() |
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (hérité de SqlSmoObject.) |
Haut de la page
Implémentations d'interfaces explicites
Nom | Description | |
---|---|---|
![]() ![]() |
IAlienObject.Discover | Discovers any dependencies. Ne faites pas directement référence à ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (hérité de SqlSmoObject.) |
![]() ![]() |
IAlienObject.GetDomainRoot | Returns the root of the domain. (hérité de SqlSmoObject.) |
![]() ![]() |
IAlienObject.GetParent | Gets the parent of this object. Ne faites pas directement référence à ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (hérité de SqlSmoObject.) |
![]() ![]() |
IAlienObject.GetPropertyType | Gets the type of the specified property. (hérité de SqlSmoObject.) |
![]() ![]() |
IAlienObject.GetPropertyValue | Gets the value of the specified property. (hérité de SqlSmoObject.) |
![]() ![]() |
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Ne faites pas directement référence à ce membre dans votre code. Il prend en charge l'infrastructure SQL Server. (hérité de SqlSmoObject.) |
![]() ![]() |
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (hérité de SqlSmoObject.) |
![]() ![]() |
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (hérité de SqlSmoObject.) |
![]() ![]() |
IAlienObject.SetPropertyValue | Sets the property value. (hérité de SqlSmoObject.) |
![]() ![]() |
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (hérité de SqlSmoObject.) |
![]() ![]() |
ISfcSupportsDesignMode.IsDesignMode | Gets a Boolean value that indicates whether the object supports design mode. Identifié à titre d'information uniquement. Non pris en charge. La compatibilité future n'est pas garantie. |
Haut de la page
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 étant thread-safe.
Exemples
Utilisation de fichiers ou de groupes de fichiers pour stocker des données
Sécurité des threads
Tous les membres publics static (Shared dans Visual Basic) de ce type sont thread-safe. Tous les membres de l'instance ne sont pas garantis comme étant thread-safe.
Voir aussi
Référence
Espace de noms Microsoft.SqlServer.Management.Smo