I'm trying to remove Auto_Increment from the column
_id in my MySQL database. However that column
is the primary key
for the table and when I'm using this command
ALTER TABLE Profile
MODIFY _id INT PRIMARY KEY NOT NULL
I get an error telling me that I can't do that since there are other tables which references the primary key
.
My question is therefore: Is there a way to get around this problem?