What is the best way to identify the right table in Clarity Database.?
Could you elaborate more on your question ?
Generally SQL trace helps in identifying the tables involved for a particular action or page visited by you.
Apart from that you can also refer the Technical Reference guide for more details about schema and associated tables.
First learn the ER diagrams in the Tech Ref to the extend that you which ones are for completely wrong entities, which ones have minor errors like missing or incorrectly labeled fields.
Then do the same for the list of tables.
Then get a listing all the real tables and their fields in the database to confirm the error as missing fields.
Compare these with the object in administration in the attributes and views to see the database fields and tables and the labels displayed to the user.
Study these and use the action trace to get case specific data.
Eventually in a few years you will know.
Retrieving data ...