Are codeunits stored in SQL?

(0) Share

Report

Posted on by Community Member

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!

I have the same question (0)

All responses (7)

Answers (1)

Liquid error: Exception has been thrown by the target of an invocation. Liquid error: Exception has been thrown by the target of an invocation.

Suggested answer

Suresh Kulla 50,241 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

gert@lynge.org on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,576 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

THE Italian on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for the explanation.

Was this reply helpful? Yes No