How to create index in PowerDesigner

In general, when I design data model in PowerDesigner, my process is:
1. Create CDM
2. Generate PDM from CDM.
3. Generate script.
If I modify data model, I modify CDM then generate to PDM, the process like above.
But, how to create an index of one table?
CDM can’t create an index, only PDM can do it.
In my process, I create an index in PDM, next time I generate from CDM, the index disappeared.

my solution

1. When generating PDM,  select "Preserve modifications" in the “PDM Generation Option” dialog
image

2.  Comparison Option set not include Table > Indexes
Click [Set As Default], next time won’t need to set again.
image

3. Generate PDM always accept all actions without remove table index.
image


display index on PDM

1. Open PDM, Select Menu > Tools > Display Preferences
Click Table
Select Index and Indicator of Index check box.

Apply to All symbols / Selected symbols.
Then it will display like below:



Popular posts from this blog

Google Map 多點路線規劃

Oppo R9 Turn on/off developer mode

解決瀏覽器無法下載檔案