Hi Jitendra, 
We can use the below given SQL to get the list of tables referencing the parent table. There is an input parameter for this SQL which is ParentTable's Physical Name.

SELECT  obj.name AS FK_NAME,    sch.name AS [schema_name],    tab1.name AS [table],    col1.name AS [column],    tab2.name AS [referenced_table],    col2.name AS [referenced_column],    '' as [logical_table_name]FROM sys.foreign_key_columns fkcINNER JOIN sys.objects obj    ON obj.object_id = fkc.constraint_object_idINNER JOIN sys.tables tab1    ON tab1.object_id = fkc.parent_object_idINNER JOIN sys.schemas sch    ON tab1.schema_id = sch.schema_idINNER JOIN sys.columns col1    ON col1.column_id = parent_column_id AND col1.object_id = tab1.object_idINNER JOIN sys.tables tab2    ON tab2.object_id = fkc.referenced_object_idINNER JOIN sys.columns col2    ON col2.column_id = referenced_column_id AND col2.object_id = tab2.object_id    where tab1.name like '%'+@EntityName+'%'     order by referenced_table

I have attached a sample OML below for your reference. I have used the mentioned SQL query in "MainFlow -> Screen1  -> GetListOfChild( Data Action)"

Hope this helps.

Hi @Daniël Kuhlmann ,

I have little bit a trick in that through the primary attribute i got from my primary entity i have got the type of every attribute of my primary entity in entity attribute table .

By using that type i have applied an filter on entity attribute table and got the list of all attribute which are of that particular and through entity attribute table i have got the Entity Id in which that referencing attribute is being used using that concept i have got the list of all associated table 

Thanks & Regards,

Jitendra