467,198 Members | 1,205 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,198 developers. It's quick & easy.

refresh view ?

Do we need to refresh a view when a table structure is altered ?. I
thought a view is just a query and it does not have to ? Please let me
know.
S

Mar 1 '06 #1
  • viewed: 6635
Share:
4 Replies
sa**********@gmail.com wrote:
Do we need to refresh a view when a table structure is altered ?. I
thought a view is just a query and it does not have to ? Please let me
know.
S

How do you alter the table structure? And which version of DB2?

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 1 '06 #2
I mean by adding adding a column and the DB2 version is 8

Mar 1 '06 #3
sa**********@gmail.com wrote:
I mean by adding adding a column and the DB2 version is 8

Adding a column has no impact whatsoever on a view.
If you happen to use "SELECT *" then the SQL Standard requires the view
NOT to pick up the extra column.
Note that "SELECT *" (especially in static objects) is by many
considered evil.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 1 '06 #4
Serge..That answers my question. Appreciate your help !

Mar 1 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Matthieu Exbrayat | last post: by
1 post views Thread by Jack Nation | last post: by
8 posts views Thread by Gerry Abbott | last post: by
5 posts views Thread by Andrew Chanter | last post: by
1 post views Thread by JIM.H. | last post: by
3 posts views Thread by David Cartwright | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.