If we have already defined foreign key constraint on a column in mysql, then after some if we want to change the column name then it can be a little bit difficult. So here i will tell you how can we rename column name with foreign key constraint in MySql query.

Suppose you have a mysql database table with some columns. And we want to change the column name later. it can be done easily with rename query. Suppose if it has been already defined a foreign key on that column, then when we run simple column name rename query. But it may lead an error in mysql query and you would get an error like below.

Query error:
#1025 - Error on rename of './learn/#sql-46c_246' to './learn/my_table' (errno: 150)

#database #rename mysql column name #mysql #mysql query