Some useful configurations of PowerDesigner for SQL Server

There are a number of problems often encountered when generating SQL Server data tables in a utility PowerDesigner:

1. The field names defined in the data are the same when the physical model is generated, an error occurs.

2. The primary key between the tables of the data cannot define the same name.

My current requirement is to design the database so that the primary key for each table is the ID, which automatically grows.

The methods are implemented as follows:

Remove the test of the name

Tools = "Check model ...

Tick out the Data Item in the error check and check the validation of name and code in the entity attribute

Tools=>model Options

Tick off the selected options.

Automatic growth of the implementation ID

Auto-grow settings are set in the physical model after the physical model is generated

Double-click the ID column

Tick this option

Then view the database code directly in the database execution is OK. However, it is important to note that this setting is confusing to the primary foreign key relationship. It is recommended to manually modify

Some useful configurations of PowerDesigner for SQL Server