Home > SQL Development > Primary Key.

Primary Key.



<i><b>Originally posted by : Padmaja Tallavajhala (coolpersona@hotmail.com)</b></i><br />I have created a table in SQL Server. How do I make a column a primary key, now that the<br />table has been created.<br /><br />Any help is appreciated.<br />Padmaja.<br />

    
Guest


<i><b>Originally posted by : Tanweer Ahmad Tajik (ttajik@yahoo.com)</b></i><br />Dear Padmaja Tallavajhala ,<br /><br />Using SQL Server Enterprise Manager Open the table in design mode(Design Table) and select the<br />field u want to set as primary key.<br />right click and Chose the "Set as Primary Key" Option<br /><br />Remember: Your fields must not have any duplicate entry . if there is any duplicate entry then modify it or select a uniqie field for primary key.<br /> <br />Regards,<br /><br />------------<br />Padmaja Tallavajhala at 6/21/2000 8:18:03 AM<br /><br />I have created a table in SQL Server. How do I make a column a primary key, now that the<br />table has been created.<br /><br />Any help is appreciated.<br />Padmaja.<br />

Was this answer helpful ? Yes No   
Guest
 
 
Home - About Infoqu - Contact - Privacy Statement - Link to Infoqu - Bookmark Infoqu

Copyright 2007-2008 by Infoqu. All rights reserved