Table Field - Where located on SQL Server?

Mog

hello,

I am searching for the Table "Field" on SQL Server. In Navision you can create a Form based on Table "Field" and it shows all fields for all tables, but I cannot find it in my SQL Server Database.

Anyone got a hint?

thanks in advance

Mog

Luc_VanDyck

You won't find it as it's a virtual table. It is build by the Navision client at run-time.

Mog

well, this destroys all my hopes

thanks a lot for your quick reply.

kriki

In SQL there is a table "syscolumns" in which are the fields.
The problem is:I don't know how they are connected to a certain table.