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.
I am having the same issue. It would be really cool if we had the option to define the Primary Key Inline or if it would do it automatically if the priamry key attribute is set to AUTO_INCREMENT.
Any ideas on getting around this issue would be greatly appreciated.
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.
O.K. We will deal with it. CR # 39 203.
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.
If you like to use e.g. CREATE DATABASE statement etc., you can write it to: Model menu | Model Properties | Before Script tab.
If you have any questions, please write us back. Thanks.