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 Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)>
Public Property FileGroup As String

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: