Microsoft Dynamics NAV (Archived)

table field actual storage

(0) Share

Report

Posted on by Sulav Thapaliya

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)

All responses (5)

Answers (1)

Luc van Vugt on at

Like (1)

Report

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

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Luc van Vugt on at

Like (1)

Report

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

Was this reply helpful? Yes No
Sulav Thapaliya 12 on at

Like (0)

Report

How can I access the Object table?

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No