4 Replies Latest reply on Jan 17, 2018 2:39 PM by Divyesh Vallabh

    Add primary key to view from Designer

    Divyesh Vallabh Newbie

      I'm having difficulty trying to figure out how to add a primary key to a model view table when in designer.


      I followed the instructions from the following two discussions:


      Adding the row_number() function and then reconciling the SQL does not generate the PK column and there is no option to manually create as suggested in the first link ( Rt-Click > New Child > Primary Key). The only two options that appear are "Access Pattern" and "Column". And without the primary key it cannot be queried via the Odata protocol


      Not sure if I'm missing something or simply looking at the wrong place. Currently using the latest JBoss Dev Studio (11.1.0) with Teiid Designer 11.1