Last updated 1 month ago
SQL Server
Azure Synapse Analytics
All of the optional clauses of the PRIMARY KEY / UNIQUE constraint are removed in Snowflake.
Syntax in SQL Server
No issues were found.
No related EWIs.
{ PRIMARY KEY | UNIQUE } [ CLUSTERED | NONCLUSTERED ] [ WITH FILLFACTOR = fillfactor ] [ WITH ( index_option [, ...n ] ) ] [ ON { partition_scheme_name (partition_column_name) | filegroup | "default" } ]
ALTER TABLE table_name ADD column_name INTEGER CONSTRAINT constraint_name UNIQUE; ALTER TABLE table_name ADD column_name INTEGER CONSTRAINT constraint_name PRIMARY KEY NONCLUSTERED; ALTER TABLE table_name ADD column_name INTEGER CONSTRAINT constraint_name UNIQUE WITH FILLFACTOR = 80; ALTER TABLE table_name ADD column_name INTEGER CONSTRAINT constraint_name PRIMARY KEY WITH (PAD_INDEX = off); ALTER TABLE table_name ADD column_name INTEGER CONSTRAINT constraint_name UNIQUE ON partition_scheme_name (partition_column_name);
ALTER TABLE table_name ADD column_name INTEGER CONSTRAINT constraint_name UNIQUE; ALTER TABLE table_name ADD column_name INTEGER CONSTRAINT constraint_name PRIMARY KEY; ALTER TABLE table_name ADD column_name INTEGER CONSTRAINT constraint_name UNIQUE; ALTER TABLE table_name ADD column_name INTEGER CONSTRAINT constraint_name PRIMARY KEY; ALTER TABLE table_name ADD column_name INTEGER CONSTRAINT constraint_name UNIQUE;
