It appears that auto_increment is showing up in SHOW CREATE TABLE output: drizzle> show create table dump_table1; +-------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | dump_table1 | CREATE TABLE `dump_table1` ( `col_char_128` VARCHAR(128) COLLATE utf8_general_ci DEFAULT NULL, `pk` INT NOT NULL AUTO_INCREMENT, `col_int_key` INT DEFAULT NULL, `col_char_10` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL, `col_bigint_not_null` BIGINT NOT NULL, `col_char_128_not_null_key` VARCHAR(128) COLLATE utf8_general_ci NOT NULL, `col_char_10_not_null_key` VARCHAR(10) COLLATE utf8_general_ci NOT NULL, `col_char_128_not_null` VARCHAR(128) COLLATE utf8_general_ci NOT NULL, `col_char_128_key` VARCHAR(128) COLLATE utf8_general_ci DEFAULT NULL, `col_enum_not_null_key` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') NOT NULL, `col_enum` ENUM('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') DEFAULT NULL, `col_bigint` BIGINT DEFAULT NULL, `col_int` INT DEFAULT NULL, PRIMARY KEY (`pk`), KEY `col_int_key` (`col_int_key`), KEY `col_char_128_not_null_key` (`col_char_128_not_null_key`), KEY `col_char_10_not_null_key` (`col_char_10_not_null_key`), KEY `col_char_128_key` (`col_char_128_key`), KEY `col_enum_not_null_key` (`col_enum_not_null_key`) ) ENGINE=InnoDB COLLATE = utf8_general_ci AUTO_INCREMENT=1 | +-------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0 sec)