Can we add a column to view ?

Questions by bsreddy4321

Showing Answers 1 - 3 of 3 Answers


  • Jun 10th, 2014

No, you cant ALTER VIEW to add or remove columns.
Need to recreate view with new column using CREATE OR REPLACE view command

  Was this answer useful?  Yes


  • Jan 18th, 2018


  Was this answer useful?  Yes


  • Jun 6th, 2018

No , new columns cannoot be added in view. The view is just a select query so it should be dropped and recreated for any such requirement.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions