Changing column name with Constraints connected to it (mysql)

Question

I have a table
car
carID
name

and another table
wheel
carID
name

Trying to change the column car.carID to ID,
I get Error on rename of...
Due to the Constraints of the wheel table,
how can I still rename the column?

(my DB is far more complex than this example, so manually is a no go)

score 0 · Accepted Answer · edited May 23 '17 at 11:55

0

can this be the option,

first delete all constraints associated with the column

change column name

again apply all the constraints

Renaming foreign-key columns in MySQL

edited May 23 '17 at 11:55

Community

1
1

answered Nov 04 '11 at 11:47

Zohaib

7,026
3
26
35

Changing column name with Constraints connected to it (mysql)

1 Answers1