SQL Server table relationships query

(0) Share

Report

Posted on by lb483

I have a requirement to update values in a number of tables supporting the NAV application. However without any formal foreign key relationships at the database level, I'm struggling to determine the child tables which also need to be updated at the same time. I've seen postings where this information can be obtained through the application but since that information must be stored somewhere in the database, is there a way to obtain the mapping programmatically? I don't need anything clever simply:

parent table, parent column, child table, child column
parent table, parent column, child table, child column_1
etc.

Is there a query available to obtain this information?

Many thanks.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Andy Sather Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

dynamicsuser.net/.../developers

I will open this up to the community in case they have something to add.

Was this reply helpful? Yes No