Hello,
If I have to update a base view definition based on the changes in the source database, I can opt for either of the following approaches :
1. I will go to Virtual DataPort Admin Tool/ Web Design Studio and click on the base view and go to Edit Tab and click on Source Refresh.
1. Or, I can develop a stored procedure using the [GET_SOURCE_CHANGES](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_source_changes) and [GET_VIEW ](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_views)stored procedures that will gather the changes in a base view definition to a separate table and based on this table script the ALTER vql statement to [Modify The Base View](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/creating_a_base_view/modifying_a_base_view/modifying_a_base_view).
You can refer to the document [How to detect Changes In Base View](https://community.denodo.com/kb/en/view/document/How%20to%20detect%20changes%20in%20data%20sources?tag=Data+Sources) to get more information about how to use the combination of GET_SOURCE_CHANGES and GET_VIEW stored procedures. Also, you can refer to the document [Developing A Stored Procedure](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/developing_extensions/developing_stored_procedures/developing_stored_procedures) for getting the steps for creating, importing and executing stored procedures.
Hope this helps!
