Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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?

like image 354
5YrsLaterDBA Avatar asked Oct 16 '25 13:10

5YrsLaterDBA


1 Answers

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.

like image 155
pascal Avatar answered Oct 18 '25 07:10

pascal



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!