Specifying sort order for SQL tables

Go Up to Sorting records

In SQL, sort order of rows is determined by the ORDER BY clause. You can specify the index used by this clause either with the

• IndexName property, to specify an existing index, or
• IndexFieldNames property, to create a pseudo-index based on a subset of columns in the table.

IndexName and IndexFieldNames are mutually exclusive. Setting one property clears values set for the other.