Skip to main content

Notifications

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

  • Suggested answer
    Saurav.Dhyani Profile Picture
    14,316 Super User 2025 Season 1 on at
    RE: table field actual storage

    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.

  • Sulav Thapaliya Profile Picture
    12 on at
    RE: table field actual storage

    How can I access the Object table?

  • Verified answer
    Luc van Vugt Profile Picture
    on at
    RE: table field actual storage

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

  • mmv Profile Picture
    11,469 on at
    RE: table field actual storage

    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.

  • Luc van Vugt Profile Picture
    on at
    RE: table field actual storage

    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).

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics NAV (Archived)

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2

#1
mmv Profile Picture

mmv 2

#1
Amol Salvi Profile Picture

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans