How to create unique index on multiple column in Azure synapse on same table

Question

Hi All

please help for How to create unique index on multiple column in Azure synapse on same table

Regards

Sanjeev

Answer 1

Hi Sanjeev,

Azure synapse does not support unique indexes, so you will have to ensure uniqueness through your load procedures.

Answer 2

Hi Daniel

Many thanks for quick reply.

Cheers

Sanjeev Chandawar