FileGroup 屬性

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

命名空間：  Microsoft.SqlServer.Management.Smo
組件：  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.ReadOnlyAfterCreation)> _
Public Property FileGroup As String
    Get
    Set
'用途
Dim instance As Index
Dim value As String

value = instance.FileGroup

instance.FileGroup = value

[SfcPropertyAttribute(SfcPropertyFlags.ReadOnlyAfterCreation)]
public string FileGroup { get; set; }

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

[<SfcPropertyAttribute(SfcPropertyFlags.ReadOnlyAfterCreation)>]
member FileGroup : string with get, set

function get FileGroup () : String
function set FileGroup (value : String)

屬性值

型別：System. . :: . .String
A String value that specifies the filegroup where the index is stored.

備註

[!附註]

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

範例

建立、改變和移除索引

請參閱

參考

Index類別

Index 成員

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

索引

CREATE INDEX (Transact-SQL)