adding constraints to a view?
This is a discussion on adding constraints to a view? within the DB2 forums, part of the Database Server Software category; --> Can we add constraints to an existing view? DB2 V8.1 AIX 5.3 Cheers, San....
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 07:00 AM
| |||
| |||
 Re: adding constraints to a view? "shsandeep" <sandeeprshah@gmail.com> wrote in message news:fb904f6875e8053f3022eb45cadeeee7@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.      |
|
02-27-2008, 07:00 AM
| ||||
| ||||
| Re: adding constraints to a view? Mark A wrote: > "shsandeep" <sandeeprshah@gmail.com> wrote in message > news:fb904f6875e8053f3022eb45cadeeee7@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 |
Linear Mode
