Viewing Thread:
"Okay, who is familiar with SQL and/or Interbase?"

How the hell do I change the primary key on a table?

Drop it...
ALTER TABLE DROP PRIMARY KEY DROP CONSTRAINT

Add a new one...
ALTER TABLE ADD CONSTRAINT PRIMARY KEY ()

You'll have to drop foreign keys on other tables that reference the column first though.

I created a table, and I've realised the primary key is wrong.

If it can't be changed, that is very gay. The user should have ultimate control. The system does not know best.

I know if I'd set it up as a constraint I could drop the constraint, but I didn't. I need to find some other way to drop the existing primary key, then I can set a new one.

The table metadata looks like this

* Table: CALENDER, Owner: SYSDBA */

CREATE TABLE "CALENDER"
(
"PROGRAMME_ID" "PROGRAMME_ID" NOT NULL,
"MODULE_ID" "MODULE_ID" NOT NULL,
"OPTIONALITY" "OPTIONALITY",
PRIMARY KEY ("PROGRAMME_ID")
);



I don't want Programme_ID as the primary key.....

Are you creating a table from scratch or using a pre-created one. You can't change it I don't think if you have already set it up as it would cause problems. I have never used the program before but used MS Access and I know you pick the primary key when you are setting it up and can't change it after that.

How the hell do I change the primary key on a table?