DROP Table & VIEW

sprasadraj · New User Joined: 09 Jul 2005 Posts: 1

Hi,

I have doubt over the SQL Stmt DROP TABLE. I see some manual(DB2 SQL Reference) specify that dropping a base table will result in the views created on the tables also getting dropped and some say that views are not dropped it is invalidated.

Practically i see the views not getting dropped when i drop the base table.

What will happen if a views is dropped? will the views created over it is
also dropped r it is invalidated?

Kindly clarify.

Thanks,
Prasad.

amitava · Active User Joined: 30 Oct 2005 Posts: 186 Location: India

I think the other views created over the deleted views are not dropped automatcally. These views become some invalidated views.