web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

table field actual storage

(0) ShareShare
ReportReport
Posted on by 12

Hello All

Where are all the table fields stored?

Is it  stored in different table which stores the detail of all the fields used in other tables?

If yes, then in which table are all those fields stored?

*This post is locked for comments

I have the same question (0)
  • Luc van Vugt Profile Picture
    on at

    The real table fields (so the data) are stored in the table itself.

    The table field definitions are stored in the Object table as part of the BLOB that contains all object specifics (for each Object record 1 BLOB).

  • mmv Profile Picture
    11,471 on at

    Hi,

    As mentioned by Luc van Vugt, the table fields (except those flowfields : you may refer this for the flowfields: dynamicsuser.net/.../97682.aspx) are stored in the table itself, you may check the tables through SQL Server Management studio, then you will have a clear picture.

  • Verified answer
    Luc van Vugt Profile Picture
    on at

    Fully right, Manesh, regarding the FlowFields. Thanx and leaves me the opportunity to also add that FlowFilter are also NOT stored in table.

  • Sulav Thapaliya Profile Picture
    12 on at

    How can I access the Object table?

  • Suggested answer
    Saurav.Dhyani Profile Picture
    14,380 Super User 2025 Season 2 on at

    Hi,

    You can access Object Table Via -

    > Code by creating a variable of Type Table (Object).

    > Create a Page on Object Table.

    You cannot see the Table as its a part of Hidden Table. For list of all hidden tables Refer below -

    saurav-nav.blogspot.in/.../microsoft-dynamics-nav-2016-navision.html

    You can also Show Details as below -

    > All Table - Refer Page 669 

    > For All Fields In All Tables - Refer Page 7702.

    ** As Mahesh & Luc Suggested You cannot See FlowFields & FlowFilters in Field Table.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans