Skip to Content
0
Former Member
May 19, 2015 at 08:45 AM

Dropping all views from a schema

347 Views

Hi,

We are facing a invalid objects problem , during DB2 upgrade to 10.5. We have been asked by sap to drop all view that belongs to a particular schema.

Could we get help on how to drop all views in a particular schema in db2 9.7 . we have around 300 views.

Regards,

Prakaash