Re: [GENERAL] alter view, add/drop column

2012-09-05 Thread Johan Nel
Dave, On Wednesday, 5 September 2012 16:16:32 UTC+2, "Gauthier, Dave" wrote: > I googled around and found that adding/dropping columns from views is not > available. (if not true, I'm all ears). > Given that, what's the best way to do this?  I was thinking along the lines > of a stored procedure

[GENERAL] alter view, add/drop column

2012-09-05 Thread Gauthier, Dave
I googled around and found that adding/dropping columns from views is not available. (if not true, I'm all ears). Given that, what's the best way to do this? I was thinking along the lines of a stored procedure that reads the view's definition, modifies it, drops the view, recreates the view.