Index.IndexKeyType Property

Gets or sets the index key type.

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 IndexKeyType As IndexKeyType 
    Get 
    Set
'Usage
Dim instance As Index 
Dim value As IndexKeyType 

value = instance.IndexKeyType

instance.IndexKeyType = value

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

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

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

function get IndexKeyType () : IndexKeyType 
function set IndexKeyType (value : IndexKeyType)

Property Value

Type: Microsoft.SqlServer.Management.Smo.IndexKeyType
An IndexKeyType object value that specifies the type of key on which the index is built, such as a unique key or a primary key.

Examples

Creating, Altering, and Removing Indexes

See Also

Reference

Index Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Indexes

CREATE INDEX (Transact-SQL)