I shows all changes you have made, as you can see in the example
Schema (MySQL v8.0)
CREATE TABLE `bar` (`id` int(11) UNSIGNED,PRIMARY KEY (`id`));
CREATE TABLE `foo` (
`id` int(11) UNSIGNED NOT NULL,
`fk_id` int(11) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
ALTER TABLE `foo`
ADD PRIMARY KEY (`id`);
ALTER TABLE `foo`
MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `foo`
ADD CONSTRAINT `foo_ibfk_1` FOREIGN KEY (`fk_id`) REFERENCES `bar` (`id`);
Query #1
SHOW CREATE TABLE foo;
| Table | Create Table |
| ----- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| foo | CREATE TABLE `foo` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`fk_id` int(11) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `foo_ibfk_1` (`fk_id`),
CONSTRAINT `foo_ibfk_1` FOREIGN KEY (`fk_id`) REFERENCES `bar` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
View on DB Fiddle