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

adding constraints to a view?

P: n/a
Can we add constraints to an existing view?
DB2 V8.1 AIX 5.3

Cheers,
San.

May 10 '06 #1
Share this Question
Share on Google+
2 Replies


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

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