Re: drop index with leading space in name
Dave Hummel wrote:
>
> Hi,
>
> It looks almost like this question was asked recently: I did a search in
> the archives but got error 404's for all the relevant messages like
> http://www.iiug.org/members/cdi_archive/1999.03/cdii.29788
>
> At any rate, how do I drop an index named ' 165_152' ?
>
> Thanks,
> Dave
Dave:
It seems to be an index related to a constraint, you don't "drop" such
indexes, instead you must alter the table:
ALTER TABLE tablename DROP CONSTRAINT constraintname;
Gabriela Bellani