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)

public:
[SfcPropertyAttribute(SfcPropertyFlags::None | SfcPropertyFlags::Expensive | SfcPropertyFlags::ReadOnlyAfterCreation | SfcPropertyFlags::Standalone | SfcPropertyFlags::SqlAzureDatabase)]
property String^ FileGroup {
	String^ get();
	void set(String^ value);
}

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: