i know synonym and alias. if the base table is dropped then synonym also will be dropped automatically.
but for alias if we drop base table, alias will not be dropped automatically.
even in absence of base table we can create the alias.
I don't have preveleage to create synonym and alias that's why i can't be able to try this problem in my system.
In DB2 reference book written by C.J DATE, it is clearly mentioned that " if we drop base table then both synonym and alias will be dropped automatically."