NAV Tab definition in SQL

drstakz
drstakz Member Posts: 30
edited 2014-05-02 in SQL General
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 ;)

Comments

  • Shedman
    Shedman Member Posts: 194
    Maybe via the Object and Field tables?
  • drstakz
    drstakz Member Posts: 30
    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
    ajayjain Member Posts: 119
    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'
    Ajay Jain
    UK

Categories