How do you identify the Primary Keys for M3 tables? Does it show you in Metadata Publisher (MDP)? If so, where do you look specifically? Thanks
Hi,
Yes MDP will show you. Search for the table you are after, open it in MDP, then click Table Index. This will give you the table indexes, any primary keys will appears as with unique as "Yes".
Cheers
Thank you!
The index with the suffix 00 is the master index for this table.
Correct - just be aware that there are a few exceptions where 00 is not the unique index. I think there are 40-50 tables out of the total 3,800 where 00 is not the unique one.
Good to know.Thank your for the remark
M3 don't have real primary keys.
Of course You can use index 00 but technically is not a real PK.
They're still Unique! Just not Primary.
Unique and Primary Key is not the same thing.
Primary Key is used to uniquely identify a row but a unique key is used to prevent duplicate values in a column.
So a Primary key is always Unique - A Unique key is not always a PK.
