SQL Server relationship

[Amar]

Can anyone tell me how to create relatioships between tables in the mssql sever 2005 ?

[Amar]

To create relationship between the database tables, go to diagrammaic representation of the databases. and then add all tables, and the creae relationships between them.

[ruchi_patel]

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.

[donald]

hey just go in diagramming representation....
you can simply create table by using this option....
and why you are using this much old version of it?
go for the newest one dear.......

[djk]

Can anyone tell me how to create relatioships between tables in the mssql sever 2005 ?

ms sql sever 2005 you can create relation using the query.
that also mention in the which language also add it.

[seanslotter]

Can anyone tell me how to create relatioships between tables in the mssql sever 2005 ?

First you must open the Enterprise Manager, create a databse then create a table with fields and assign the primary key in your field. If your table is more than one go to Relationship Table then drag your first table which is your primary key going to an another table which had a foreign key.

[anurdh65]

set a primary key for master table & set a foreign key for the transaction table then link the two tables by connecting those fields groupby command or use a join commands

[seanslotter]

set a primary key for master table & set a foreign key for the transaction table then link the two tables by connecting those fields groupby command or use a join commands

This tip will you doing in Query Analyzer. Thanks for additional tips.

[anurdh65]

is this tip useful for you please reply to my gmail id anurdh65@gmail.com

[donald]

set a primary key for master table & set a foreign key for the transaction table then link the two tables by connecting those fields groupby command or use a join commands

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...???