Nav "Fields" table: Does it exists on SQL Server?

txerifftxeriff Member Posts: 492
Hi,

I was looking for the table called "Field" in sql server but cannot find it. Is it an internal table?

It shows all fields from any table. You ca browse it by making a new form and typing "Field", then retrieve all the fields.

Any idea?

thanks! :)

Comments

  • krikikriki Member, Moderator Posts: 9,086
    It doesn't exist in SQL. It is a virtual table in NAV.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • txerifftxeriff Member Posts: 492
    kriki wrote:
    It doesn't exist in SQL. It is a virtual table in NAV.

    thanks for the response.

    And how does nav make it? Does it use any view or something I could use from sql server?
  • DenSterDenSter Member Posts: 8,304
    Virtual tables are pieces of data that the NAV executable collects at runtime, and represents as a table structure, so that we can access it in C/AL code as if it were a table. As Alain said earlier, virtual tables do not exist on SQL Server.
  • archer89archer89 Member Posts: 337
    the get the field names in sql you can use the sql system tables.

    select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS
    where TABLE_CATALOG = <databasename>
    and TABLE_NAME = <tablename>
    -- and ORDINAL_POSITION = <field no.>
    best regards
    Franz Kalchmair, MVP
    Alias: Jonathan Archer

    please like / agree / verify my answer, if it was helpful for you. thx.
    Blog: http://moxie4nav.wordpress.com/
  • txerifftxeriff Member Posts: 492
    DenSter wrote: »
    Virtual tables are pieces of data that the NAV executable collects at runtime, and represents as a table structure, so that we can access it in C/AL code as if it were a table. As Alain said earlier, virtual tables do not exist on SQL Server.

    thanks. I though they exist somewhere.
Sign In or Register to comment.