locked
primary key (Referential Integrity) RRS feed

  • Question

  • I need help with Primary key to handle duplicate data load. Azure SQL Data Warehourse doesn't support Primary Key.

    I see below error when i try to create primary key. Can any one help

    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.

    Thanks

    Kumar

    Friday, May 10, 2019 5:56 PM

All replies