Options

Is there a means in MS Dynamics NAV of knowing all the tables used by a program?

Is there a means in MS Dynamics NAV of knowing all the tables used by a program without going to the program code?

Answers

  • Options
    tirthankar_btirthankar_b Member Posts: 8
    Hi Veder,
    Whats the version you are using.??
  • Options
    MisConsultngMisConsultng Member Posts: 17
    Search for a program called Statical Prism. It’s a must have tool for any NAV developer. You can use it to find where a particular field or table or function is used in the code. They have a free trial version that you can download though the paid version is much more robust in features.
  • Options
    Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    What for? If you want just the table names you can go the SQL Server Management Studio and run
    this SQL query:
    yt6a12yonlmb.png
    That will give you almost complete list of all the table names (a bit distorted) used by your NAV
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
Sign In or Register to comment.