3 Replies Latest reply on Jan 9, 2015 9:08 AM by tdanner

    How to list detailed Orion table column definitions / schema (e.g., field lengths)

    toneill2000

      I would like to know how I can extract the detailed column definitions for my Orion tables. It appears they are stored in SQL Server and I'm using the SWQL Studio program.  I've tried the "DESC" statement but that just gives an error. For example...  DESC Orion.Nodes

      ... will give me an error saying "mismatched input 'DESC' expecting 'SELECT'" 

       

      Therefore, I assume DESC is an invalid command even though SWQL highlights it blue like a it's keyword.  Any help would be greatly appreciated. Thank you in advance.