Key field in views RRS feed

  • Question

  • Can you tell me what criteria is used in determining the key field in a view (Field Name, Field position, etc)?

    I added row_number text below to two views that would not import into my model.


    Select row_number() OVER (ORDER BY Name ASC) AS RowID, Name, etc...


    One view will not import. I get the error message

    The table/view  does not have a primary key defined and no valid primary key could be inferred. This table/view has been excluded. To use the entity, you will need to review your schema, add the correct keys, and uncomment it. 


    The view does function and the RowID does list unique numbers. Any ideas?

    Monday, October 4, 2010 7:06 PM