Hello,

I'm using FireBird 1.0.3 and stumbled on the following problem:

How to rename/drop/alter a Primary or Foreign Key without knowing it's exact name but knowing the tables and fields it uses and it is for?

Is there a clean way to do this in a sql script (not using any db management tools)?

I hope my question is clear enough and you will help me.



Best regards,



Iliya Iliev


[Non-text portions of this message have been removed]