I have installed the latest copy of Toad Data modeller beta 3. Itried to use it to generate SQL script of one of my reverseengineering database from mysql 5. On the release notes said, thisbeta version have updated the Mysql DDL script generation aboutcreate primary key as a part of create table statement.Unfortunately, it does not do it.
“Createprimary key is part of create table statement.” CR 36309
Itstill using the sql ALTER TABLE ‘table name’ ADD PRIMARY KEY (
asa statement to create the primary key.
Iam wondering if it is a bug or i mis-understood the update.
Becausefrom my point of view, i think the meaning of “Create primary keyis part of create table statement” is like below.
CREATE TABLE example( id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name VARCHAR(30), age INT) Please let me know if you want me to explain more. Many thanks Chi