How to set Foreign Key

Posted by Oswaldlily under Sql Server on 12/14/2012 | Points: 10 | Views : 1149 | Status : [Member] | Replies : 3
How to set Foreign Key ? without writing sql query..

[I need systematically using right click option]




Responses

Posted by: Ranjeet_8 on: 12/14/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
Look at this url
http://www.ezineasp.net/post/Create-Foreign-Key-on-SQL-Table-Column-using-SSMSE-2005.aspx

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sandeepmhatre on: 12/15/2012 [Member] Starter | Points: 25

Up
0
Down
Step by step approach to create a foreign key is described here

http://sandeepmhatre.blogspot.in/2012/12/create-foreign-key-foreign-key-in-one.html

Sandeep M,
Software Developer
Follow me on :
http://sandeepmhatre.blogspot.in

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 3/20/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi

Right Click -> relationship -> Add-> Table and Column Specification and Set them.

Mark as Answer if its helpful to you

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response