On Fri, 30 Oct 2020, Adrian Klaver wrote:
It should be: alter table locations drop constraint 'constraint_name';
Adrian, Yes, I forgot to quote the constraint_name, And, I used the DDL name 'unique' rather than the internal name "locations_loc_nbr_key". Using the latter, and adding 'cascade' (because the dependent table is empty) did the trick. Thank you, Rich
