Toad World® Forums

Question about DDL Script on MYSQL5 Model


#1

Hi

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 (table_ID) ;
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

#2

Chi,

I’m very very sorry. There was a misunderstanding in our team. This CR has been reopened finally. Our developers need to further deal with it.
So, the CR # 36 309 is still open.

Let me apologize.

Vladka