how to add primary key in existing table
This is a discussion on how to add primary key in existing table within the SQL Server forums, part of the Microsoft SQL Server category; --> i have table fff .it has two fields one is fno int , another is fname varchar(20) fff fno ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 08:11 PM
| ||||
| ||||
 how to add primary key in existing table 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      |
|
02-29-2008, 08:11 PM
| ||||
| ||||
| Re: how to add primary key in existing table 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/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
Linear Mode
