By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,752 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

refresh view ?

P: n/a
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
Share this Question
Share on Google+
4 Replies


P: n/a
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

P: n/a
I mean by adding adding a column and the DB2 version is 8

Mar 1 '06 #3

P: n/a
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

P: n/a
Serge..That answers my question. Appreciate your help !

Mar 1 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.