Add a composite key to MS SQL 2000 server
Account Home | Help | Blog | Contact us | Log Out


Welcome to Kbytes > Articles

Add a composite key to MS SQL 2000 server

Posted By: siteadmin on 15/04/2012 14:55:00

Add a composite key to MS SQL 2000 server

This short video shows how to Add a composite key to MS SQL 2000 server.  I was using the shift key, but it wasn't working (clearly)!  So I switched to the CTRL key and then it worked just fine.

ALTER TABLE tablename
ADD CONSTRAINT uc_NameofConstraint UNIQUE (column1,column2)  
 
Will do it in script.

 


blog comments powered by Disqus

Kbytes Home | Privacy Policy | Contact us | Testing Area

© 2004 - 2018 1 Oak Hill Grove Surbiton Surrey KT6 6DS Phone: +44(020)82617371