Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
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,745 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans