Answers

• SruthiA Administrator

  July 2021

  @miiclaudia : you cannot update the view. you need to drop it and recreate view by adding 2 columns that you want to add.

  0
• Jim_Knicely - Select Field - Administrator

  July 2021

  Can't you do a CREATE OR REPLACE VIEW?

  1
• miiclaudia Community Edition User

  July 2021

  Dear Jim, the case is not permit include the new two fields in Create or replace view. =(

  0
• Jim_Knicely - Select Field - Administrator

  July 2021 edited July 2021

  @miiclaudia - Not sure what you mean. Do you not have the database privileges to run a CREATE OR REPLACE VIEW?

  0