how to add primary key in existing table

Giganews Newsgroups
Subject: how to add primary key in existing table
Posted by:  surya (suryait…@gmail.com)
Date: 17 Aug 2006

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

Replies