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
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.