Hello all,
Is there a way to drop indexes that were created without a given name?
I have a test table with indexes named 'Index_4C" etc etc, and I can't
drop them. Those indexes using "create index on TABLE(COLUMN)" and
unnamed.
Thanks.
Duncan.
--
You received this message because you are subs
What happens when you try to drop them? Do you get an error message?
This works ok for me:
create table blah(id int, name varchar);
create index on blah(name);
select INDEX_NAME from INFORMATION_SCHEMA.indexes where table_name = 'BLAH'
drop index INDEX_1 -- (where INDEX_1 is the value returned i