CODEWITHSUNDEEP
sql-server-2008
larryq
larryq

Reputation: 16299

SQL 2008 Management Studio-- where to find table relationships?

I'm brand new to SQL Server 2008, and have some newbie questions about the diagram pane. I just dragged two tables onto it to do an inner join, and the console "knew" to create a one-to-many relationship between them. Where is this information kept in the Management Studio for me to look at closer?

Thanks!

Upvotes: 1

Views: 4420

Answers (2)

meklarian
meklarian

Reputation: 6625

Much of this information is actually available in system tables in the database containing the user tables.

Here are two of the available tables of interest. sys.tables contains table information, sys.foreign_keys contains relationship information via foreign key constraints.

sys.tables (Transact-SQL) @ MSDN
sys.foreign_keys (Transact-SQL) @MSDN

Also handy is the following information on Pinal Dave's site on using this information for your own lookups.

Find tables with Foreign Key Constraint in Database @ SQLAuthority.com
Find Relationship of Primary key and Foreign Key using T-SQL @ SQLAuthority.com

Upvotes: 2

user121301
user121301

Reputation:

One of the tables has a foreign key referencing the other table. In Object Explorer, expand the information for the tables involved and look under Keys.

Upvotes: 1

Related Questions