asked
How to ADD and DROP a Primary Key to a table
Can some me show me how to write the code for dropping the Primary Key on a table. I am learning SQL and have a hard time dropping key. Below is what I typed to add and drop and is not working for me To ADD a Primary Key after the table is created: Alter table Customers ADD Primary Key CustomerNumber int Not Null Error I got was: Msg 102, Level 15, State 1, Line 2 Incorrect syntax near 'CustomerNumber' To Drop PK I used the following code: Alter table Customers Drop Primary Key CustomerNumber Error I am getting is :Msg 156, Level 15, State 1, Line 2 Incorrect syntax near the keyword 'primary'. Thank-you
A primary key is a table constraint, not an independent object. To add a primary key after creating the table, you need to ADD a CONSTRAINT: alter table Customers add constraint PK_Customers primary key (CustomerNumber) and to drop it: alter table Customers drop constraint PK_Customers
14 People are following this question.
