IBM Mainframe Forum

Hi,

In our environment we have arequirement to drop a database(Test Region).

If we drop a database what are all the other objects or any other (like plan, package, etc...) has to be dropped explicitly?

Our Findings(Correct me If I am wrong)...

We came to know that
Tablespace, Indexspace, Synonyms, Views, Sequence Objects are dropped implicitly.

My findings:

Needs to be explicitly taken care after DROP DATABASE

Triggers,
Plan/Package,
Stored Procedures/Function
Alias.

Correct me, If I am wrong in above list.

Happy Learning,
Dinesh Kanna.