title: How to set any column as primary key in Azure SQL data warehouse
body: <p>I am trying to set one column in DB as primary key but I always get this error:</p>
  
  <blockquote>
    <p>Enforced unique constraints are not supported in Azure SQL Data Warehouse. To create an unenforced unique constraint you must include the NOT ENFORCED syntax as part of your statement.</p>
  </blockquote>
  
  <p>While doing R &amp; D,I found that there is no concept of primary keys &amp; foreign keys in Azure SQL data warehouse then how can we accomplish this in it.</p>
  
  <p>Any ideas?</p>