A great example on why you should use surrogate keys, such as an AutoInc, instead of natural keys. No need to change the PK.


>Hi,
>I have table as below with PK crefdoc+nsn, how could I change the PK to crefdoc+cbzunit using T-SQL?
>
>

CREATE TABLE [dbo].[fbzplnd] (
>	[crefdoc] [char] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
>	[nsn] [decimal](3, 0) NOT NULL ,
>	[cbzunit] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
>	[nvalue] [decimal](10, 2) NOT NULL
>) ON [PRIMARY]
>

>Thank you