I have created a table on Toad Data Modeller, I try to use the SQL script that generated by “DDL Script Generation function” to create the table and primary key. Unfortunately when I run the sql script on MySQL Query Browser It display an error message “Incorrect Table Definition; there can be only one auto column and it must be defined as a key”
I guess that problem occur is because the primary key is created after the creation of the table. Is there any way I can get around this problem if not I would be grateful if that problem can be solve in next beta.
Another thing I would like to mention is in MySQL only 1 column in a table can be use as auto-increment. Would it be possible to have little bit validation when you design/create the table in toad, if you detect there has anther field that has been set to auto-increment in the same table, it would notice the user.
Another feature I would like to add on Toad data modeller is, to allow user to change some settings on the database E.g. Collation, type …etc.
And also provides an option for the user which could allow whether they want the “DDL Script Generation function” to generate the Database script for them. E.g. Create Database script.
Please let me know if you want me to explain more.