4

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

pascal
  • 3,287
  • 1
  • 17
  • 35
5YrsLaterDBA
  • 33,370
  • 43
  • 136
  • 210

1 Answers1

8

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.

pascal
  • 3,287
  • 1
  • 17
  • 35
  • 1
    I will add to your answer, that I found that `Identity` checkbox is in physical diagram, exacly where you say. I am just clarifying that, because I was looking for it in conceptual data model and it wasn't there. – Konstantinos Raptis Jan 16 '21 at 00:17