Add a composite key to MS SQL 2000 server

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

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