DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT | WITHOUT TYPE]
I want to allow to DROP VIEW if any objects depend on it.
Am I right, If we leave (or convert) TYPE linked to VIEW, then DROP will be possible?
No...you can't write "select * from type_name" and that is going to be the most common kind of dependency you have to deal with.