Indexes with columns using DESC sort order

[keith-hall]

Given the following script:

CREATE NONCLUSTERED INDEX [IX_Test_1] ON [dbo].[Test]
(
    [TestID] DESC
)

SchemaZen currently does not honor the column sort order, and scripts it as:

CREATE  NONCLUSTERED INDEX [IX_Test_1] ON [dbo].[Test] ([TestID])

Column sys.index_columns.is_descending_key can be used to determine if a column in an index should be sorted in descending order.

[benjamin-hodgson]

This issue is affecting me too.