Skip to Content
0
Former Member
Apr 30, 2018 at 02:09 PM

Auto increment for Primary Key in Powerdesigner

4820 Views

Hello,

I am creating a data model in power designer. Could you please help me on auto increment for a PK column. I am trying to enable auto increment for PK column by checking "Identity" but I am getting error while executing the script in MySQL.

Error Code: 1075
Incorrect table definition; there can be only one auto column and it must be defined as a key