how to add primary key in existing table

[surya]

i have table fff .it has two fields one is fno int , another is fname
varchar(20)
fff
fno fname
-------- -----------
100 suresh
102 ramesh
here there is no not null constraint and identity column then
i am add primary key constraint fno column pls help me

[Erland Sommarskog]

Re: how to add primary key in existing table

surya (suryaitha@gmai l.com) writes:

i have table fff .it has two fields one is fno int , another is fname
varchar(20)
fff
fno fname
-------- -----------
100 suresh
102 ramesh
here there is no not null constraint and identity column then
i am add primary key constraint fno column pls help me

ALTER TABLE fff ADD CONSTRAINT pk_fff PRIMARY KEY (fno)

You find the syntax for ALTER TABLE in Books Online. Yes, it is quite
complex. Then again, there are quite a few examples in that topic.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx