I’ve created an Alter script on MySQL 5.1 database. When the script tries to drop the tables, it first drops the indexes, then the Primary key and then the table.
I get an error when it tries to drop the Primary Key, because the AutoIncrement value is still set to True.
Am I doing something wrong with the alter script creation or should the alter table statement for the AutoIncrement value to be removed rather be added.
Currently I have to drop ALL the AutoIncrement values in my diagram and then add them again after creating the script. Dropping them is easy by using JScript, but adding them must take place manually (busy building a bigger script) because not all my primary keys are autoincrement fields.