I want to insert data into table in Azure Synapse
Input
Table A
ID
1
1
1
2
3
Only ID one record should be stored in destination.How to have constraint defined in destination table.
Output
Table B
ID
1
2
3
This does not work Msg 104467, Level 16, State 1, Line 1
Enforced unique constraints are not supported. To create an unenforced unique constraint you must include the NOT ENFORCED syntax as part of your statement