--non clustered and unique index

Create Unique Nonclustered Index U_refCode on CustomerDetails(
  refCode desc
)