I have 49 columns in my table foos which has 14 indexes (FK, PK, UQ). Since I want to drop all tables which are being referenced in this table, I need to first drop all FKs. But I have many FKs.
In order to drop all 10 keys, I need to:
- click on drop icon.
- It displays a confirmation dialog box. I should click on "Yes".
- Then it will display again "operation successful" dialog where I should click on "Ok" button again.
So, to trop 10 keys, I need to press 30 buttons. It's very annoying. Imaging I have 50 indexes. What's then?