We are upgrading PRPC6.3 to PRPC 7.1.8 from single schema to split schema process. After upgrading the old dataschema to 7.1.8 there is one process mentioned in 7.1.8 upgrade document " cleaning up unused tables". From Optimizing Schema option we have to select the Data schema to delete the unused Rules schema from the old schema. Now if we want to run that clanup manually, how can we generate the script with all unused tables to be dropped?
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
As of now there is no OOTB way to generate the unused tables script, you have to manually identiy all the table lists from Optimize schema wizard for both Rules and Data schema then write SQL queries to drop those tables from respective schemas.