try this and let me know

Line "and Parent.user_type_id =36" is for uniqueidentifier

and

Line "AND Child.is_identity+1=Parent.is_identity"(which is comment in this query) is for column which is

identity column in primary...

is your Person_Id column is "identity column" in Primary table

second option for the same requiment

declare @temp table(t varchar(50))

insert into @temp

select * from

(

values

('a.p'),

('y.a.p'),

('k.p')

)a (name)

select *

from @temp

where CHARINDEX('.',t,CHARINDEX('.',t)+1)=0

can you tell me more in detail whats happening and what is output when you run

few field and few tables means?

if its fine to you can you share some...

try this one

DECLARE @testtable TABLE (id INT, value INT, NAME CHAR(4));

INSERT INTO @testtable

VALUES

(1, 10, 'test'),

(2, 5, 'prod'),

(3, 10, 'test'),

(4, 4, 'test'),

(5, 4, 'test'),

(6, 4, 'test'),...

Ok,column which is having identity will be parent table and second one will act as as child

and yes if column name is same both tables then only query will work...

Hi,

I havnt got your question fully but i assume that you want to find tables that "can have relation

base on the column name"

Like Parent table having USERID as primary...