I have created external list to retrieve SQL data into my SharePoint via External Content Type (ECT). Everything working fine till here but the problem is when ever i want to add a new column to the External list.

So to add a new column in the external list i am doing the following 3 things every time.

  1. Adding a column by altering SQL table
  2. Remove existing operations in the existing External content type and reconnect to the table to get the new column into ECT>
  3. Remove the existing external list and recreate to get the new column.

By doing the above 3 things i am loosing the custom forms (Edit, New, Display) which are associated to my external list.

Can someone please advice how can i modify my external list with a new column with out disturbing my external list custom forms.

1 Answer 1


You do not have to delete the existing external list and recreate one. In the existing list, just modify the view and add the new column to your view.

enter image description here

enter image description here

  • Thanks Michael....It's working and saved my time. Commented Nov 17, 2020 at 8:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.