Primary Key with 3 field By Query

Nikki

8y729

I have a table with 9 fields. I created a primary key of 3 field in management studio. But I dont know to create primary key of 3 field by query. Kindly help me.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Code Alone8y ago
Accepted answer
Hi,

If you create PK by multiple fields after the creation of table. You can create PK by below query.
ALTER TABLE [dbo].[tb_city]
ADD CONSTRAINT [PK_tb_city] PRIMARY KEY CLUSTERED
(
    [state_id] ASC,
    [country_id] ASC,
    [city_name] ASC
)
Note :
be sure there are fixed fields(mean no udefine length field like NVARCHAR(MAX))
Be sure that there are no primary key already on that table. If you have primary key before on that table then you must delete them. To delete Primary key you can take help of my Previous below article: https://www.c-sharpcorner.com/article/find-primary-unique-foreign-keys-and-delete-them/
You can find self solution for these type of issue by right click on table then script table as then Create to
Code Alone8y ago
In third point I was talking below
Then you will find query for table creation. Put the marked code with ALTER TABLE statement and add this constraint.

I was talking about this solution.
Suraj Kumar8y ago
Hi Nikita,
You can create composite primary key by selecting multiple column of a table in design view and clicking on set primary key option of suggested cotext menu options. It has been shown below by image

Once you will do it will create primary key on selected columns as below

I think this was said by Pradeep in third point.

Regards
Suraj
Nikki8y ago
Thank you for the revert. It solve my issue.
Will you explain third option in note??