Subject Re: [firebird-support] Re: Rename Primary Key Foreign Key or Index
Author Martijn Tonies
> and I have a Primary Key on Field1.
> I want to change the Primary Key to be on Field3.
> The problem is that I don't know the name of the key!!!
> I know I can see it using either a sql script or any db management utility
> but my script has to work on databases with PK with different names and
> should be done ONLY using sql script
> So as far as I can tell I have to find a way to change the definition of
> PK in the system tables or find a way to drop it and create the new one

In short - there's no command like:


That would be a nice addition, but currently, there isn't one.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions