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

txeriff

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!

kriki

It doesn't exist in SQL. It is a virtual table in NAV.

txeriff

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?

DenSter

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.

archer89

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

txeriff

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.