quote:

---

Originally posted by Idera

You want to do that using a SQL query?


Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH

---

SELECT	object_name(fk.parent_object_id) parentTable, pc.name parentColumn,
	object_name(fk.referenced_object_id) referencedTable, rc.name referencedColumn
from	sys.foreign_keys fk
join	sys.foreign_key_columns fc
on	fc.constraint_object_id = fk.object_id
join	sys.columns pc
on	pc.object_id = fk.parent_object_id
and	pc.column_id = fc.parent_column_id
join	sys.columns rc
on	rc.object_id = fk.referenced_object_id
and	rc.column_id = fc.referenced_column_id

quote:

---

Originally posted by russell

this ought to point you in the right direction

SELECT	object_name(fk.parent_object_id) parentTable, pc.name parentColumn,
	object_name(fk.referenced_object_id) referencedTable, rc.name referencedColumn
from	sys.foreign_keys fk
join	sys.foreign_key_columns fc
on	fc.constraint_object_id = fk.object_id
join	sys.columns pc
on	pc.object_id = fk.parent_object_id
and	pc.column_id = fc.parent_column_id
join	sys.columns rc
on	rc.object_id = fk.referenced_object_id
and	rc.column_id = fc.referenced_column_id

---

quote:

---

Originally posted by russell

Cascading deletes is always a bad idea. We don't allow it in any circumstances in our databases.

It introduces difficult to track down bugs, causes inadvertant data loss.

And it is the lazy way out.

---

 
Select 
     cast(c.name as  varchar(255)) as foreign_table
    , cast(fc.name as varchar(255)) as  foreign_column_1
    ,  cast(p.name as varchar(255)) as primary_table
    , cast(rc.name as varchar(255))  as primary_column_1
    from sysobjects f
    inner join sysobjects c on  f.parent_obj = c.id
    inner join sysreferences r on f.id =  r.constid
    inner join sysobjects p on r.rkeyid = p.id
    inner  join syscolumns rc on r.rkeyid = rc.id and r.rkey1 = rc.colid
    inner  join syscolumns fc on r.fkeyid = fc.id and r.fkey1 = fc.colid
    left join  syscolumns rc2 on r.rkeyid = rc2.id and r.rkey2 = rc.colid
    left join  syscolumns fc2 on r.fkeyid = fc2.id and r.fkey2 = fc.colid
    where f.type =  'F'
    and  p.name=@TableName
 ORDER BY cast(p.name as varchar(255))