CODE EXAMPLE FOR SQL

tsql create unique index composite

CREATE UNIQUE INDEX index1 ON schema1.table1 (column1 DESC, column2 ASC, column3 DESC);