database design

[Rupa Kalluru]

Hi everbody, Iam currently working on datbase design. Iam stucked at:If a primary key is assigned in database,I need to know all the foreign key relation of this PK on other tables in that database. please help out on this, thanks in advance, Rupa

Rupa

[Lost User]

Seems to me you need to learn the basics. http://www.htmlgoodies.com/primers/database/article.php/3478051[^] is a series of articles. You should use google [^] to search for Database basics tutorials

[ednrgc]

Primary keys and foreign keys are the backbone for how tables relate to each other.

[Rupa Kalluru]

I need to know the tables which are in related with the same foreign key. Pls do tell the table which constitutes the FK available in the database. Means that IS there any table in the database in SQL SERVER which is having the FK's.sitting in it. Please try to understand the query first,then reply it in more meaning manner

Surya

[Pete OHanlon]

If I understand your question properly, you want to be able to find out which tables have FKs pointing to a PK. To do this, you need to look in the tables sysobjects and sysdepends (plus syscolumns for column names). The xtype in sysobjects lets you specify PK for primary keys. I hope that this helps.

Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world." Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that." Deja View - the feeling that you've seen this post before.