Detect relationships between tables in SQL Server

[ahaupt]

Hi,

I need to write an app that will detect the relationships (as well as
their type) between tables in SQL.

Anyone came accross something like this before? Any help will be
greatly appreciated.

Thanks,
Andre

 

[Abdellah Elamiri]

checkout sysforeignkeys table, and sysobjects
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-f_39v7.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-o_4zll.asp

hope this helps

 

[ahaupt]

That's brilliant! Just what I was after. Thank you.

Just for interest sake; I don't suppose there's a type of general
library one could use to detect these relationships between other
databases (like oracle, access, mysql...)

Best

 

[Octavio Hernandez]

Hi,

Just for interest sake; I don't suppose there's a type of general
library one could use to detect these relationships between other
databases (like oracle, access, mysql...)

..NET 2.0 will add new possibilities for getting database metadata in a
generic way, maybe this should help. Check:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/adonet2schemas.asp

Regards,

Octavio

 

[ahaupt]

Excellent.

Thanks for that.

Hi,


.NET 2.0 will add new possibilities for getting database metadata in a
generic way, maybe this should help. Check:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/adonet2schemas.asp

Regards,

Octavio