i want to make a composite primary key useing 2 column.
so what the way for this in sqlserver.

abhinavjain

__________________
abhinavjain

note that any field in a PK cannot allow nulls.

In design view of enterprise manager.
Hold down the shift key, highlight both fields, right click, set primary key.

or

ALTER TABLE [dbo].[TABLE] WITH NOCHECK ADD
    CONSTRAINT [TABLE] PRIMARY KEY CLUSTERED
    (
        [FIELD1],
        [FIELD2]
    ) ON [PRIMARY]
GO