Share via


IndexedColumn.Descending Property

Gets or sets the Boolean property value that specifies whether the indexed column is sorted in descending or ascending order.

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

Syntax

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

value = instance.Descending

instance.Descending = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design|SfcPropertyFlags.Deploy)]
public bool Descending { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design|SfcPropertyFlags::Deploy)]
public:
property bool Descending {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design|SfcPropertyFlags.Deploy)>]
member Descending : bool with get, set
function get Descending () : boolean 
function set Descending (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether the column is sorted in descending or ascending order.If True, the column is sorted in descending order.If False (default), the column is sorted in ascending order

Examples

Creating, Altering, and Removing Indexes

See Also

Reference

IndexedColumn Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Indexes

CREATE INDEX (Transact-SQL)