Iliya,
You could use isql and issue the "show index;" command to list all of your
indexes and the tables/columns. This gives all the info that you will need.
Rich P....

-----Original Message-----
From: Celyo [mailto:iliev@...]
Sent: 03 October 2003 11:49
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Rename Primary Key Foreign Key or Index


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]



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/