Index.IsClustered Property

Gets or sets the Boolean property value that specifies whether the index is clustered.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design Or SfcPropertyFlags.Deploy)> _
Public Property IsClustered As Boolean 
    Get 
    Set
'Usage
Dim instance As Index 
Dim value As Boolean 

value = instance.IsClustered

instance.IsClustered = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design|SfcPropertyFlags.Deploy)]
public bool IsClustered { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design|SfcPropertyFlags::Deploy)]
public:
property bool IsClustered {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design|SfcPropertyFlags.Deploy)>]
member IsClustered : bool with get, set

function get IsClustered () : boolean 
function set IsClustered (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies the whether the index is clustered.If True, the index is clustered. Otherwise, False (default).

Examples

Creating, Altering, and Removing Indexes

See Also

Reference

Index Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Indexes

CREATE INDEX (Transact-SQL)