811c6dd5   
   From: reb01501@NOyahooSPAM.com   
      
   mada suresh wrote:   
   > Hi friends,   
   >                  A pleasant greetings for one and all.I have the table   
   > which name is ALA.It has a column id.i set id as primary key.Can any   
   > one help me .please.   
   >   
   > i tried this query but no use,,,   
   >   
   > alter table ala drop primary key;   
      
   ALTER TABLE dbo.ALA   
    DROP CONSTRAINT name_of_primary_key_constraint   
      
   If relationships/foreign keys referencing this column exist, you will likely   
   have to drop those as well.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)