We want to delete the lower version rules from the system after skimming

what are all the tables and SQL queries we should use to delete the lower version rules, All at a time. Instead of individual running of Delete ruleset wizard

Scenario :
We have skimmed the Portal Ruleset to new major version 03.

We want to delete all the lower version rules (01-xxxx and 02-xx-xx).

What are the tables we should look to delete the records?

What will be the Delete queries with where clause?

Any post deployment steps after deleting the records from DB?

Note: There are few rules in pega (Rule-Obj-Class, Rule-Library etc ) which are not version specific and they only belong to RuleSet, those should not be deleted from the system.

***Updated by moderator: Lochan to add Categories***

**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.