Can we add a column to view ?

Questions by bsreddy4321

Showing Answers 1 - 9 of 9 Answers

ALOK342

  • 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

patelmosin

  • Jan 18th, 2018
 

Yes

  Was this answer useful?  Yes

Souravi

  • 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