• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 501
  • Last Modified:

how to view tables and relationships between them in sql server 2005

whats the best free available tool to view the tables and relationships between them in sql server 2005
0
mmalik15
Asked:
mmalik15
1 Solution
 
Swadhin RaySenior Technical Engineer Commented:
Check Microsoft SQL Server 2005 Express Edition Service.

You can also use SQL Developer from Oracle. Its a free tool provided by Oracle but it has a facility to connect to SQL Server database .
0
 
Alpesh PatelAssistant ConsultantCommented:
Just create Database Diagram from Node above the tables and you can see relationship in diagram.
0
 
David ToddSenior DBACommented:
Hi,

Do you have Visio? That can do the job.

Regards
  David
0
 
mmalik15Author Commented:
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
0
 
mmalik15Author Commented:
i was looking for the above if it helps anybody
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now