Extract Relationship from MS SQL
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi Exprets, I am making an application using MS SQL Server and I need to know that what kind of relationships are existing between table e.g. 1-1 or 1-M. I can get the constraint's, coulumn, table, types information from INFORMATION_SCHEMA at this point but I still need to find the relationship types between tables. I am using C# and ADO.NET and the version of Database Server right now is MS SQL Server 2000 but Finally I will be utilizing MS SQL Server 2005. Any idea, suggestion, snippet? Thankx