FIELD table where to find it in SQL

kamalbaaklini

Hello,
i am trying to find a SQL table or SQL view that shows similar data as the "FIELD" table found in NAV system table (2000000041).

who can find it?

](*,)

thank you

mohana_cse06

Field is a virtual table..
A virtual table contains information provided by the system. In C/SIDE, you have access to a number of virtual tables. They work in much the same way as normal database tables, but you cannot change the information in them. That is, you can only read the information. Another difference is that virtual tables are not stored in the database (as normal tables are) but are computed by Microsoft Dynamics NAV at run time.

thmartin

I wouldn't call that "not stored in the db"

http://stackoverflow.com/questions/21223762/read-dynamics-nav-table-metadata-with-sql