Hi All,I am very new to sql and I have got this doubt.CREATE TABLE employee{ EMP-ID VARCHAR UNIQUE, DESIG VARCHAR UNIQUE, SALARY INT };Probably this is worst table ever created :).Now How to drop UNIQUE constraint on only column lets DESIG.if i writeALTER TABLE employeeDROP CONSTRAINT myuniqueconstraint;
will drop constraints on both columns which I dont want.Please suggest a query that remove UNIQUE CONSTRAINT only on DESIGN column.and one more clarification,ALTER TABLE employeeMODIFY SALARY INT NOT NULL;ALTER TABLE employeeALTER COLUMN SALARY INT NOT NULL;
which of the above two is right query to add NOT NULL constraint to the above employee TABLE?Please help folks!
How to drop UNIQUE CONSTRAINT on only one column
Posted - 2014-05-05 : 02:15:42
