How to create an auto-increment primary key in PowerDesigner - How to create an auto-increment primary key in PowerDesigner

Time: 2022-10-12Source: Huajun Software TutorialAuthor: blue thin mushroom

      近日有一些小伙伴咨询小编PowerDesigner怎么创建自增主键?下面就为大家带来了PowerDesigner创建自增主键的方法,有需要的小伙伴可以来了解了解哦。

Step 1: First create a table, which includes two fields, id and name. The id should be set as an auto-incremented primary key, as shown in the figure below.


Step 2: Then set the id as the primary key, click on the Primary column in the id, and select it, as shown in the figure below.


Step 3: Double-click the information in the id column to bring up the maintenance page of the column information, as shown in the figure below.


Step 4: Find the identity (feature) in the lower right corner and click to select it, as shown in the figure below.


Step 5: We open the preview page, browse the table creation statement, and find that the id field has changed to auto-increment, so the creation is successful.


Step 6: We can paste this sql and execute it on the mysql client tool.


The above is the entire content of how to create an auto-incremented primary key in PowerDesigner brought to you by the editor. I hope it can help you.

Related articles更多>>

Popular recommendations