The documentation of the CREATE TABLE
syntax for Azure SQL Data Warehouse does not mention CHECK
constraints at all, nor any other type of constraints except for NOT NULL
and DEFAULT
constraints.
I assume that CHECK
constraints are not supported in this product.
Simple talk article: Taking Azure SQL Data Warehouse for a Test-Drive by Robert Sheldon, says it clearly:
Working with tables
When working with the SQL Data Warehouse version of a T-SQL statement, you’ll often find that the syntax is similar to how the statement is implemented in SQL Server or SQL Database. However, the SQL Data Warehouse version of a statement is usually not as extensive and sometimes supports options specific to SQL Data Warehouse, as we saw with the CREATE DATABASE
statement.
The same can be said of the CREATE TABLE
statement. It does not support many options available to SQL Server or SQL Database, and there are a couple options specific to SQL Data Warehouse. For example, the statement does not support primary keys, foreign keys, check constraints, unique constraints, unique indexes, computed columns, sparse columns, user-defined data types, indexed views, identities, sequences, triggers, or synonyms. The statement also does not support certain data types, such as geometry, geography, hierarchyid, and so on. At the same time, the CREATE TABLE
statement provides table options that are unique to SQL Data Warehouse or handled differently from standard T-SQL.