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)

No code example is currently available or this language may not be supported.

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: