Not supported
Data type that cannot participate in a columnstore index:
- xml
- binary
- varbinary
Constraint:
- No Primary and foreign Key. Seeprimary-and-foreign-key-constraints
- Enforced unique constraints are not supported. To create an unenforced unique constraint you must include the NOT ENFORCED syntax as part of your statement.
- Clustered primary key constraints are not supported in Azure SQL Data Warehouse. Explicitly create an unenforced NONCLUSTERED primary key constraint instead.
Upload
Bulk insert is now MS SQL Server - bulk copy program utility (bcp)
Doc: bcp
Syntax
Primary Key
Actually, you can't define a primary key in a create table or alter table column statement (for now 20180219, you can only define a default constraint). You still can define a primary key if you add a column.
ALTER TABLE dbo.DimAccount
add columnNamePK int
CONSTRAINT PK_DimAccount PRIMARY KEY NONCLUSTERED NOT ENFORCED;
- Delete
ALTER TABLE dbo.DimAccount drop constraint PK_DimAccount;
ALTER TABLE dbo.DimAccount drop column columnNamePK;