Hi,

i want to get foreign key details for some validation

foreign key name | owner column | Referred Table | Referred column

of a specified table

how can i do it?
please help me
thanks
:)

jomet.
---------------------------------------------
Once you start a working on something,
dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.

I believe the following is what you're looking for:

SELECT OBJECT_NAME(constid), target_table.name AS target_table, target_column.name AS target_column,
    source_table.name AS source_table, source_column.name AS source_column
FROM sysforeignkeys fk
INNER JOIN sysobjects target_table ON fk.fkeyid = target_table.id
INNER JOIN syscolumns target_column ON fk.fkeyid = target_column.id AND fk.fkey = target_column.colid
INNER JOIN sysobjects source_table ON fk.rkeyid = source_table.id
INNER JOIN syscolumns source_column ON fk.rkeyid = source_column.id AND fk.rkey = source_column.colid
ORDER BY OBJECT_NAME(constid), target_table.name

Good luck.

Mark

Thanks for your solution.


jomet.
`````````````````````````````````````````````````` ``````````````````````
Once you start a working on something, dont be afraid of failure and dont abandon it.
People who work sincerely are the happiest.