i want to get all the tables which dosent have parental referencial integrity but having child referencial integrity, i.e.,
consider a table T1 which has columns T1C1 and T2C2 . consider another another table T2 having column T2C1,T2C2 and T3C3. Now T1 is parent table to T2 and T1 dosent have any parent table, consider that T1C1 is a PK of T1 and T2C2 have FK constrain on T1C1, i.e., we cant insert into T2C2 if the that value is not present in T1C1 .
Now i want to get all the such table [T1] from the database , do i have any system tables, so that i can write a query and fetch those tables easily or is there any other methods to list such tables ?