understanding relation b/w tables

Question

0.00/5 (No votes)

See more:

ASP.NET

if project contains 70 tables . how i can understand relationship b/w
those tables

Posted 1-Sep-10 2:06am

venu-manula

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandesh M Patil · Answer 1 · 2010-09-01T02:41:00

Use below one

SQL

Select
object_name(rkeyid) Parent_Table,
object_name(fkeyid) Child_Table,
object_name(constid) FKey_Name,
c1.name FKey_Col,
c2.name Ref_KeyCol
From
sys.sysforeignkeys s
Inner join sys.syscolumns c1
on ( s.fkeyid = c1.id And s.fkey = c1.colid )
Inner join syscolumns c2
on ( s.rkeyid = c2.id And s.rkey = c2.colid )
Order by Parent_Table,Child_Table

or

I test below one working just paste it in SQL server Query window & execute

SQL

select object_name(constid) FKey_Name, object_name(fkeyid) Child_Table, c1.name FKey_Col,
object_name(rkeyid) Parent_Table, c2.name Ref_KeyCol
from sysforeignkeys s
inner join syscolumns c1
on ( s.fkeyid = c1.id
and s.fkey = c1.colid  )
inner join syscolumns c2
on ( s.rkeyid = c2.id
and s.rkey = c2.colid  )

or

Google is your friend
:)

Simon_Whale · Answer 2 · 2010-09-01T05:06:00

1. If your on about relationships at a database level, assuming there is a documentation look at that

2. If your after how to make relationships between the tables in ADO.NET then have a look at this example

edit

to look at the details of one particular table primary key / indexes etc. In SQL Server type exec sp_help tablename where tablename is the actual table you want to know more about

aswathy.s.88 · Answer 3 · 2010-09-01T05:00:00

Solution 2

In the query window select table name and press Alt+F1. There u will get relations of the particular table with other table...

Posted 1-Sep-10 5:00am

aswathy.s.88

Comments

Sandesh M Patil 1-Sep-10 11:21am

Reason for my vote of 1
I am getting Help window...what r you trying to say please explain

Simon_Whale 1-Sep-10 12:03pm

press alt and F1 in the query windows (sql 2005 / 2008) but it shows all the tables / stored procedures / views for that particular database your on

understanding relation b/w tables

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0