Re: alias for long object name

On Fri, 25 Jul 2003 17:53:29 GMT, Karsten Farrell <kfarrell_at_belgariad.com> wrote:

...
>If I add a column to the table (or drop a column), I have to remember to
>update the view as well (unless it's simply select *).
...
'select *' is converted to 'select col1,col2,...' in the stored view definition, so if you drop a column for instance, the view will become invalid and won't compile.

Jaap. Received on Sat Jul 26 2003 - 11:50:14 CDT