Any suggestions? Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Index.FileGroup Property

 

Gets or sets the filegroup where the index pages are stored.

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

[SfcPropertyAttribute(SfcPropertyFlags.None | SfcPropertyFlags.Expensive | SfcPropertyFlags.ReadOnlyAfterCreation | SfcPropertyFlags.Standalone | SfcPropertyFlags.Matrix)]
public string FileGroup { get; set; }

Property Value

Type: System.String

A String value that specifies the filegroup where the index is stored.

System_CAPS_noteNote

For indexes based on the UserDefinedTableType object the filegroup is provided by sys.indexes and the value of FileGroup property is ignored.

Return to top
Show:
© 2016 Microsoft