MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE A (
  id INT AUTO_INCREMENT PRIMARY KEY
);

CREATE TABLE B (
  id INT,
  A_id INT NOT NULL,
  FOREIGN KEY (A_id) REFERENCES A(id)
);
ALTER TABLE A MODIFY id INT COMMENT 'id of user';
Cannot change column 'id': used in a foreign key constraint 'B_ibfk_1' of table 'fiddle_QRWRNHMDZUJZMSOMEJXT.B'

ALTER TABLE A MODIFY id INT AUTO_INCREMENT COMMENT 'id of user';
show full columns from A


Field
Type
Collation
Null
Key
Default
Extra
Privileges
Comment


id
int
null
NO
PRI
null
auto_increment
select,insert,update,references
id of user