Setting RecId as PrimaryKey produces two PK's in SQL

Finance and Operations/AX Developer Forum
1

Hi and thanks in advance for any help you can provide.

I am working with a table in ax and trying to set just its RecId field as the Primary Key. After doing so I look at the table in SQL Server and find that BOTH RecId and DataAreaId fields have been made a Primary Key. I have tried a bunch of thing but can’t get it to just set the RecId. What can I do to make only the RecId the Primary Key???

We have someone working to optimize our database and they need only the RecId to be the Primary Key for this particular table. That is the reason for this question.

Thanks!

Bob

2

You have to set table’s “SaveDataPerCompany” property to No.

3

Hi Martin,

Thanks for the reply, much appreciated. That did the trick!!

Bob