NAV Tab definition in SQL

drstakz

Hi,
simple question :-) Is it a possible find NAV Table definition direct from SQL. Concretely I mean Fields Name, Fields ID (maybe Type, Description, Relation.. or other)

I have just written simple app in C# and I'm reading this data from an exported table (txt file). But this is not dynamical at changes in NAV.

Thanks for info

Shedman

Maybe via the Object and Field tables?

drstakz

hmm.. for NAV 2013 I found this link
http://devch.wordpress.com/2014/01/21/a ... revisited/

So I can read tables definition direct from SQL for NAV2013, but it's not possible for NAV 2009, because 2009 has different compress method for BLOB.

Table definition is in SQL in table "Object Metadata"

ajayjain

SELECT obj.object_id,obj.name as Table_Name,Cols.name as Column_Name
FROM sys.objects as obj,sys.columns as Cols
WHERE
obj.object_id = Cols.object_id
AND obj.name='CRONUS UK Ltd_$Acc_ Schedule Line'