How can I Delete/Alter Unique Constraint

Hi All,

How can I delete Unique Constraint/ Alter Unique Constraint.

example

tblStudent
=======
stdid
stdname
classid

previously I gave stdname as UNIQUE
but I need to alter it as UNIQUE (stdname,classid)

Just it is an example, donot ask why not more than one student with same can
exist in one class.

Thanks alot,

With Best Regards,
Sreedhar Bhaskararaju 1,2nd Main Road, KottuGardens, Chennai - 600 085 Ph :
4475111 Email : shreedhar@lucidindia.net