Changing Key Column From INT to VARCHAR

[swisstoni]

Hey,

I'd like to change my key column in a table from an auto increment Integer to a VarChar, but MySQL wont let me do this.

Whenever I try to change the type, I get MySQL error 1025 - error renaming table.

I think it's probably because the key is referenced in other tables as a foreign key as type INT (though feel free to correct me if I'm wrong!)

Any idea how I could go about cascading this change onto the other referenced tables?

 

[swisstoni]

Ah, apologies - got it sorted - just deleted the foreign keys, changed the type and set the keys back up!