How do i ensure that when i want to get rid of a company, i get rid of all the tables and dd and everything for that company?

Also I reclaim all the freed space (at the database level)

Thanks

Do a "delete tables" for all tables of that company (ttaad4231m000 - Tools/Database Management).

This wil perform "drop table" commands on your database, so the database engine should free all the space.

Check if any of the tables are shared between companies!

Normally you must not delete any data dictionary related things, since they are stored by package combination, not by company.

Uli

If each company has it's own tablespace(s), you may also want to drop them from the database.
Regarding the DD, this is created by package combination not by company.

If you drop tablespaces, their physical data files continue to remain.
You need to remove those data files used by dropped tablespaces physically.
Then, only you can see increase in free space.

Take care that this step is executed only after drop of tablespaces is successful.

Thanks