Search code examples
mysqlpowerdesigner

How to enable PowerDesigner 16.5 auto increment primary key for MySQL database?


I am using PowerDesigner 16.5 to model my MySQL database. Anybody knows how to enable its auto-increment primary key feature?


Solution

  • On the property sheet for the column, I have a Identity checkbox, which changes the column datatype to int, and add auto_increment after the column in the generated SQL.