How to modify/add columns to a custom view (and transport this changes)

hello 

In 1IM 8.1.5 i've created a custom view (using Create View in Schema Extension tool) to expose some information to api consumers and it works fine.

Due to changing requirements i need to add/remove/rename columns to that view, the view does not appear on the list displayed on Extend Table option in Schema Extension, is there any other option to modify the underlaying SQL code using the designer or other tool ?

Using the Delete option and then recreate the view from scratch is my last option (and Delete schema extensions objects is not supported in Productive level databases as i understand so transport is not possible ) 

Parents Reply Children
No Data