Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

Are codeunits stored in SQL?

Posted on by Microsoft Employee

Hi,

We're using NAV 2017 as our ERP system. I have access to the Development Environment, but only with limited license. Of course, the limitations are quite frustrating, especially when you just want to review customizations.

I was able to lookup codeunits via debugger, but I heard it's possible to see them in the SQL database. Weirdly, I do have access to it, however, I can't locate them. If they are stored in SQL, then were I should look?

Thanks!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Are codeunits stored in SQL?

    Thanks for the explanation.

  • Verified answer
    THE Italian Profile Picture
    THE Italian on at
    RE: Are codeunits stored in SQL?

    This is not possible. Otherwise there will be a leak in Intellectual Property (IP) protection. Codeunit are stored as binary cyphered and compressed objects within the database. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Are codeunits stored in SQL?

    Thanks. I don't want to edit them, I'm looking for a way to view the codeunits or export them in bulk. I hoped that I could find those records somewhere in the SQL database.

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: Are codeunits stored in SQL?

    Eventually you have SQL Database behind so this way or the other everything in SQL but that doesn't  mean you can manipulate those from SQL end.

  • Suggested answer
    RE: Are codeunits stored in SQL?

    Yes, all objects are stored in the SQL database, but not in an easily retrievable way. So I don't think you will be able to easily retrieve them from SQL.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Are codeunits stored in SQL?

    Thank you for your answer. Are codeunits stored as a files then?

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,640 on at
    RE: Are codeunits stored in SQL?

    They are not stored in SQL.  You need to get license to access them or modify them.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans