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" are returned.

See Also