#15875: Adding primary key using the Alter Table tool results in an error

alonsomendez reported 2021-11-18T16:07:59Z · last modified 2021-11-18T20:48:46Z

Adding primary key using the Alter Table tool results in an error

Dev	tomconrad
QA	Lwaugh

Priority	Major
Complexity	Unknown

Component	DB - MS SQL Server
Version	Future

Aqua Data Studio seems to be generating the wrong Alter Script when modifying a table to add a Primary Key on MS SQL Server, which results in the attached error. Steps to reproduce:

-Navigate the Schema Tree to any created table.

-Right click the table and select Alter Table

-Add a Primary Key in the Constraint tab.

-Click Alter in the top left corner of the tool.

Case 00919429

1 attachment

error.png

2021-11-18T16:07:59Z

93 KB

All Comments (1) Change History

tomconrad 2021-11-18T20:24:13Z

This clause was added by mistake when we added Azure Data Warehouse since some code is shared with SQL Server. See ScriptConstraint->scriptCREATE. Search for "NOT ENFORCED"

Search Tips

Aqua Data Studio / nhilam

Adding primary key using the Alter Table tool results in an error

1 attachment

Issue #15875

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Adding primary key using the Alter Table tool results in an error

1 attachment

Issue #15875

Completion