Feel free to email me with any comments or feedback about what I have written here on this page.
-
When a table is created and you allow the default primary key name of idTableName to be generated then the
datatype is Integer and the AI (Auto Increment) flag is on by default. If you change the datatype of the primary
key to another type such as Varchar, then you must also uncheck the AI flag, as DBDesigner will leave the AI flag on
even when you change the datatype to Varchar. This will not show up as a problem until you try to run your create
script on your database. I learned this the hard way.
