oracle - Getting an invalid ALTER TABLE option -


this exact query erroring out

  alter table indil_mcar drop constraint abob.indi_mcar_pk; 

i m trying remove unique key constring table. gives me following error.

 ora-01735: invalid alter table option 

you can't prefix constraint name... table name yes, not constraint name. remove abob.:

alter table indil_mcar drop constraint indi_mcar_pk; 

Comments