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