adding constraints to a view?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shsandeep - 10 May 2006 06:22 GMT

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

Cheers,
San.

Reply to this Message

Mark A - 10 May 2006 07:10 GMT

> 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.

Reply to this Message

Knut Stolze - 10 May 2006 07:59 GMT

>> 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).

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message