0 Replies Latest reply on Jul 15, 2013 3:19 PM by cgregors

    SQL Query to get node custom properties

    cgregors

      I know this will work in 10.4.2 :

       

      select

          syscolumns.name as [Column],

          syscolumns.colid

      from

         sysobjects, syscolumns

      where

          sysobjects.id = syscolumns.id and

          sysobjects.name = 'Nodes' and

          colid > 82

       

      But I'm hoping someone has a better way of extracting a list of custom properties.