Powerdesigner sets auto-increment Columns

Powerdesiner's auto-increment column, which was previously generated after an SQL statement, then added identity () to the auto-increment column. After searching for a long time, we finally got the method.

1. if the DBMS is MSSQL, after selecting the table, database-> edit current DBMS-> the DBMS Properties dialog box appears, select the general page, in the left-side tree, select SQL 2000-> profile-> column-> extended attributes. The extidentityincrement under extenbutes is the step value, and the extidentityseed is the start value. Set the default values respectively, and then return.
2. In the Properties dialog box of the table, select the clumns page and press Ctrl + u to hook up before idenitity. If necessary, you can also
The extidentityincrement and extidentityseed are also checked, so that you can directly specify the start value and step value when setting idenitity.
BTW: I used pd11. I just started learning PD. I have been searching for identity settings for a long time.

3. for QL Server, In the table Properties dialog box, select the clumns page, press Alt + enter to go To the attribute page of the column, and check the idenitity attribute in the lower right corner.