SQL Server relationship

[anurdh65]

Hi,

Using a primary key @ master table is to create the relationship for the child tables. You can create a primary key as well as foreign key for one table. The main purpose of foreign key is the entity relationship only

[donald]

Hi,

Using a primary key @ master table is to create the relationship for the child tables. You can create a primary key as well as foreign key for one table. The main purpose of foreign key is the entity relationship only

yes i got a little bit more idea for that...
but my confusion is that should i have both key in the same table or i can make both key in different table also...???
and primary key must be unique..???

[hiren_mehta007]

hey what is the benefit to create a primary key in master table...?
can't i make it in my 2nd table??
and i am facing problem while making foreign key...
please can you tell me how it can be created...???

If you are making primary key for master table it is called parent and if you are making primary key for other table it is called foreign key.....

[promotor]

To create relationship between the database tables, go to diagrammaic representation of the databases. and then add which tables you wants to relation and thecreate relationships between them.