> 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

the

> PK in the system tables or find a way to drop it and create the new one

In short - there's no command like:

ALTER TABLE table1 DROP PRIMARY KEY;

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
http://www.upscene.com