Adding primary key to table

[RebLazer]

I need to add a primary key on column name "primary_key" to an already-existing table "dbo.select3rd". I know I need to use the "alter table" command but I can't get the syntax right.

Any help would be very appreciated!
Thanks!
Lazer

 

[JayKusch]

ALTER TABLE [dbo].[select3rd] WITH NOCHECK ADD
CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED
(
[primary_key]
) ON [PRIMARY]

Thanks

J. Kusch

 

[RebLazer]

Thank you, Jay!

 

[tb]

Try this (Suggest test environment)

CREATE TABLE test ( column_a INT)

ALTER TABLE test ADD
/* Add a PRIMARY KEY */
PK_Column varchar(20)
CONSTRAINT column_b_pk PRIMARY KEY
/* Add a default value */
CONSTRAINT AddDflt
DEFAULT 1 WITH VALUES

Tested this in northwind db
Hope this helps
Have fun!



The pen is mightier than the sword - and quite frankly . . easier to write with

 

[RebLazer]

Thank you very much, too, theB______!


Lazer