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?