"Challenge" <ha********@yahoo.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
Hi,
I have a table creation script that generated by ERWin. An index name
is too long and has been truncated as "XPKsp_prj_stk_ord_". Now I want
to drop and recreate it as another name. I got error when I drop it:
SQL0204N "SPARADM.XPKsp_prj_stk_ord_" is an undefined name.
SQLSTATE=42704
How can I drop it?
I've never used ERWin but shouldn't the DB2 Control Center be able to drop
the index? Just list all the indexes for the table, then use the GUI to
delete that specific index.
Or do you absolutely have to know how to drop it through ERWin?
--
Rhino