Table modifications effect in DB

Finance and Operations/AX Developer Forum
1

Hi

Can any one give me answer please.

we are using sql as database for ax , now when I create a table in ax and if I do any changes it will reflects in sql , and

if I create a table in sql will it be reflect in ax or not? if at all reflects, how and why ? if not reflected why?

Thanks in advance

2

AX saves application objects in application files or modelstore database (depending on the version) and database synchronization reads information about application objects and create corresponding database objects. It will never read database object and try to create AOT objects for them.

3

Hi Martin,

Many thanks for your reply.

as per your suggestion if we create table in SQL it will not show any impact to Ax.?

Can you please elobrtae.Thanks In advance

4

Hi Martin

Can you please elaborate.

If we create any table in SQL db , it will show impact in AX and Vice versa?

5

Please read my answer again and tell me which part you don’t understand. I thought it’s clear, but you either didn’t read it or didn’t get it.

In addition, NEVER change AX database schema directly; always do it through AOT.