DB2 question - views

View, as it well known, is basically a SELECT, applied on a physical table or another view (nested).
I have 2 questions.

1. Where is view stored? I mean the view definition itself. Like for example table info is in SYIBM.SYSTABLE etc.

2. If I drop a table, which has views, what will happen with the views? Will they be

a. deleted automatically?

b. stay in the system and return an error when somebody try to use them?

c. drop will be aborted with the message that I have to drop all related views first?

Many thanks to the one, who answers.

Hi,

View definition will be stored in SYSIBM.VIEW ayatem table.

If you drop a table the related view will not be dropped automatically.

It will be marked inoperatable.