Open Forum

Expand all | Collapse all

SQL table showing table names and column names (not just ID)?

  • 1.  SQL table showing table names and column names (not just ID)?

    SILVER CONTRIBUTOR
    Posted Nov 07, 2019 10:37 AM
    Is there a SQL table that will give me a cross reference of NAV Table No, NAV Table Name? Also, NAV Field No, NAV Field Name?

    For instance, when I query the change log table, I only see references to [Table No_] and [Field No_], but no readable names. Several tables have these references.



    I can get the readable name in the client or look it up manually in the Dev Environment, but I would like to join it in SQL. Does anyone know a spot where I can find this information?

    Thanks!

    ------------------------------
    Heather Walters
    Apothecary Products
    Burnsville MN
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: SQL table showing table names and column names (not just ID)?

    SILVER CONTRIBUTOR
    Posted Nov 07, 2019 10:53 AM
    Edited by Rick Tweedle Nov 07, 2019 10:54 AM
    The Object table has the table info you need
    select * from [Object]

    Type = 1 for table

    The field level data I'm not sure where it comes from though (other than the virtual field table in the object designer)

    ------------------------------
    Rick Tweedle
    BC/NAV Dev Manager
    Columbus Global
    Temecula CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: SQL table showing table names and column names (not just ID)?

    SILVER CONTRIBUTOR
    Posted Nov 07, 2019 10:55 AM
    That is just what I was looking for! Can't believe I didn't find that myself. Thanks!

    ------------------------------
    Heather Walters
    Apothecary Products
    Burnsville MN
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role