Subject RE: [firebird-support] Rename Primary Key Foreign Key or Index
Author Richard Pendered
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
Subject: [firebird-support] Rename Primary Key Foreign Key or Index


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

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:

Your use of Yahoo! Groups is subject to