Adding a primary key to a column that already exists.

[mattyp75]

How do I add a primary key to a column that already exists.
I've tried:
ALTER TABLE dbo.CensusSourceData_Ilot
ALTER COLUMN Column1
ADD CONSTRAINT Column1_pk PRIMARY KEY

but that doesn't work.

It seems a simple thing to do, but I can't see how to do it anywhere on the web. Any help would be much appreciated

thanks,
Matt

 

[LFCfan]

ALTER TABLE [dbo].[MyTable] WITH NOCHECK ADD 
	CONSTRAINT [PK_MyTable] PRIMARY KEY  CLUSTERED -- or NONCLUSTERED
	(
		[MyColumn]
	)  ON [PRIMARY] 
GO

HTH

 

[JamesLean]

alter table table_name
add constraint pk_name primary key (col_name)

--James

 

[mattyp75]

Thanks guys. Was starting to get a little frustrated there.
All is working now.