Primary Key with 3 field By Query

Question

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.

Code Alone · 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 Alone · Answer

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 Kumar · Answer

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

Nikki · Answer

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