Access to change logs

Hi Team,


Can you pls clarify here like in our 2 tables we do have a relationship through which we get values?

Can you pls explain do we have any interlinked relationship between 2 objects? 


For example in HDFC Revenue and Revenue booking has one to many relationships Revenue booking is linked with Revenue ID?

Do we have the same type of relationship in the audit log also? Can you pls confirm it will be better for me to execute queries?

Like 0




You can follow this example to find out what relationship some table has. 

You can do the SELECT from 'YourTable' to check the relations that this table has.

The detailed info can be found with the help of the query:

SELECT * FROM information_schema.columns where table_name = 'YourTable'

Please use it to find the dependencies.

Kind regards, 

Show all comments