467,199 Members | 981 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

adding constraints to a view?

Can we add constraints to an existing view?
DB2 V8.1 AIX 5.3

Cheers,
San.

May 10 '06 #1
  • viewed: 1641
Share:
2 Replies
"shsandeep" <sa**********@gmail.com> wrote in message
news:fb******************************@localhost.ta lkaboutdatabases.com...
Can we add constraints to an existing view?
DB2 V8.1 AIX 5.3

Cheers,
San.


I assume you are talking about a CHECK OPTION constraint. They can only be
defined with the CREATE VIEW and not with ALTER VIEW.
May 10 '06 #2
Mark A wrote:
"shsandeep" <sa**********@gmail.com> wrote in message
news:fb******************************@localhost.ta lkaboutdatabases.com...
Can we add constraints to an existing view?
DB2 V8.1 AIX 5.3


I assume you are talking about a CHECK OPTION constraint. They can only be
defined with the CREATE VIEW and not with ALTER VIEW.


My guess would be that he talks about additional conditions in the WHERE
clause of the SELECT statement in the view. But the same considerations
apply there, i.e. you have to drop and re-create the view (and all the
objects that depend on it).

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
May 10 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by Agoston Bejo | last post: by
10 posts views Thread by Eric Petruzzelli | last post: by
13 posts views Thread by Bruno Panetta | last post: by
3 posts views Thread by Andreas Fromm | last post: by
reply views Thread by BobTheDatabaseBoy | last post: by
9 posts views Thread by Edmund Dengler | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.