You can modify a primary key in sql server 2017 by using sql server management studio or transact-sql. you can modify the primary key of a table by changing the column order, index name, clustered option, or fill factor.. Create primary key - using alter table statement. you can create a primary key in sql server (transact-sql) with the alter table statement. however, you can only use the alter table statement to create a primary key on column(s) that are already defined as not null.. If you define a compound key, the order of columns in the primary key matches the order of columns as shown in the table. however, you can change the order of columns after the primary key is created. for more information, see modify primary keys. using transact-sql to create a primary key in an existing table.
If an attempt is made to delete the row in a primary key table or to change a primary key value, the action will fail when the deleted or changed primary key value corresponds to a value in the foreign key constraint of another table.. I recently came across this issue and found the least painful solution was to download the database from azure, restore it locally, update the primary key locally (as the key constraint is a sql azure specific issue), and then restore the database back into azure.. I want to modify an existing primary key on a sql azure table. it currently has one column, and i want to add another. now, on sql server 2008 this was a piece of cake, just did it in ssms, poof. done..
