• Hi,

    Please find the following few tables for your reference

    --Person

    Enterpriseid

    Person_Id

    LastName

    FirstName

    --Person_Relationship

    Person_Id

    Relations_Code

    CreatedDate

    --Person_Employers

    Person_Id

    Employee_id

    Occuapation

    Person,Person_Relationship and Person_Employers are tables.

    The common field is Person_Id, But there is no Foreign Key relationship. Like this i have 3000 tables without having Foreign Key relationship

    Is there any way can we get all tables relationship through Person_Id Field? like this we have lot of common field names.

    Using this i want to find which all tables are linked without foreign Key relationship.

    Regards,

    tony