List of Tables has Case ID

General
, , , , ,
1

Hi ,

I would like to know if there is a way to pull list of all tables where specific case ID(s) is/are stored.

So far i have collected these tables, but i guess there will be more. Is there a definite list of tables where i should be looking at.

TableName - ClassName

ABCD_Work - ABCD-Work
pc_assign_worklist - Assign-Worklist
pc_assign_workbasket - Assign-WorkBasket
pc_data_workattach - Data-WorkAttach-
pc_link_attachment - Link-Attachment
pr_data - Data-Corr-Email

I am using Pega 6.3

2

@Bharathan

One option could be to take a random case ID , create and run a query to search entire database. This query should give all table name where the case ID is present in any column of the table. You can search online for the query based on the underlying DB that is used.

Thanks!