Partilhar via

  • Artigo

GetIndexedColumnDESC Method

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

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

Sintaxe

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);

Comentários

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.

ObservaçãoObservação

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

Consulte também

Referência

SetIndexedColumnDESC Method