How to set any column as primary key in Azure SQL data warehouse

azure-sql-database azure-sqldw
shweta_kaushish picture shweta_kaushish · Apr 20, 2018 · Viewed 11.5k times · Source

I am trying to set one column in DB as primary key but I always get this error:

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.

While doing R & D,I found that there is no concept of primary keys & foreign keys in Azure SQL data warehouse then how can we accomplish this in it.

Any ideas?

Answer

DEEPAK LAKHOTIA picture DEEPAK LAKHOTIA · Apr 22, 2018

Azure SQL Data Warehourse doesn't support Primary Key.

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-overview

Related questions

EXTERNAL TABLE access failed due to internal error: 'Java exception raised on call to HdfsBridge_IsDirExist. Java exception message:

I am trying to create external table through polybase with below syntax on Visual Studio 2015. Its giving me the below error. Can some one pls help on this CREATE EXTERNAL TABLE dbo.DimDate2External ( DateId INT NOT NULL, CalendarQuarter TINYINT …

Read More
DROP TABLE IF EXISTS not working on Azure SQL Data Warehouse

I used the SQL Server management studio to generate script against Azure Data Warehouse. I selected Edition Azure Data Warehouse, it generates below the script to drop table if it exists and create table. However, the script cannot pass validation. …

Read More
Azure SQL Data Warehouse DWU vs Azure SQL DTU

I am considering migration from Azure SQL to Azure SQL Data Warehouse. It seems to offer some of the features that we need, however price is a concern for starting small. 100 DWU Data Warehouse is priced considerably higher ($521/month) than …

Read More