Use Guid type in SAP PowerDesigner

Question

I would like to use a GUID for the type of my primary key.
Do you know how to do that in SAP powerdesigner 16.5 ?

If you plan to use GUID as your primary key and create a clustered index then I recommend using NEWSEQUENTIALID() since you should NOT use the GUID column as the clustering key — Dylan KAS, Aug 02 '19 at 08:10

Toothgip · Accepted Answer · 2019-08-07T09:00:46.047

2

I finally add an other data type in the tab attribute of an Entity which I called UUID and generate a UUID in SQL which is a recognized type

edited Aug 07 '19 at 09:00

answered Jul 30 '19 at 12:31

Toothgip

Thanks for answering your question.. How did you implement it? A default value, or a insert trigger? – pascal Jul 31 '19 at 07:29
I used UUID type and it was recognized in PostgreSQL so i didn't need to add an insert trigger i generate the UUID before inserting in the table – Toothgip Aug 06 '19 at 12:36

1 Answers1