This topic has not yet been rated - Rate this topic

GetIndexedColumnDESC Method

SQL Server 2008

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

TheGetIndexedColumnDESC method specifies whether the sort order of a column in an index is descending.

Syntax

object.GetIndexedColumnDESC(ColumnName)as Boolean

Parts

object: Expression that evaluates to an object in the Applies To list.
ColumnName: String that specifies the column name.

Prototype (C/C++)

HRESULT GetIndexedColumnDESC(
SQLDMO_LPCSTR ColumnName, 
LPBOOL pRetVal);

Remarks

By default, columns in an index are sorted in ascending order. GetIndexedColumnDESC returns TRUE if the sort order of the specified column is descending.

Use the SetIndexedColumnDESC method to specify that a column in an index must be sorted in descending order.

Note
If an application calls SetIndexedColumnDESC on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.

Applies To:

Index2 Object

Reference

SetIndexedColumnDESC Method

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD