Posted by Erland Sommarskog on 08/17/06 22:28

surya (suryaitha@gmail.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@sommarskog.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

• Next in forum: Re: Access to SQL Server Query Translation
• Prev in forum: Re: SQL Server 2005 Opening Script File Problem
• Thread view: Re: how to add primary key in existing table

[Reply to this message]