We are currently trying to understand the relationship between External Content Types and External Lists within SharePoint 2013. We have a read-only ECT which we defined based on a SQL Server View. After creating the ECT and the associated List with multiple views we determined that there were columns which were missing from our SQL View.
I was able to update the Read List and Read Item operations to include the additional columns but I am unable to get those additional columns to be made available to the External List associated with the ECT.
I have tried creating a new List based on the same ECT and it also does not display the new columns.
Is there a method or update that I need to run to allow the new columns to be available to the External List? If I recreate the ECT it will see the new columns but I am trying to avoid having to re-create the ECT each time this change is necessary.
Please let me know if you have any suggestions on how to make these additional columns show up in an External List.
Thanks,
Josh