Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sandhya
Starting Member
2 Posts |
 Posted - 2008-05-14 : 17:46:38
|
| I know the method where you select each and every table and manually create foreign key relationships to other tables in the database visually or by sql. Is there any way in SQL server 2005, to create these relationships using wizard, where it checks for the same column names in different tables and creates the relationships. If yes, please let me know how to do it in SQL server 2005. |
|
|
ranganath
Posting Yak Master
209 Posts |
Posted - 2008-05-15 : 01:44:19
|
| Hi,Using ManagementStudio you can create Relationships |
 |
|
|
Sandhya
Starting Member
2 Posts |
Posted - 2008-05-15 : 09:29:18
|
| Will you please explain the procedure, as how it can be done. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-15 : 09:40:11
|
| Right click table- Modify - Choose table designer - you can create relationships. |
|
|
|
|
|
|
Creating relationships--Help needed