Re: SQL 2005 Express Table Relationships

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Well, if you are using SQL Server Management Studio Express then you can create a Database Diagram.


Connect to your server, then access <ServerName> -> Databases -> <DatabaseName> -> Database Diagrams.
If you don't already have a diagram then you can create one by right clicking on Database Diagram and selecting "New Database Diagram". Then select your tables and drag the fields needed in the relationship togather. For a one -> many just make sure that one of the two fields is a key.

I'm also quite new with SQL express so don't use me as gospel. I'm sure someone else around here might have more info.

Also keep in mind that you can build the relationship as part of a query in Access with the Query builder almost exactley like with a MDB, though I'm not too sure if that comes with a slight performance hit or not.


On Fri, 03 Aug 2007 04:14:37 +0200, Charlie <jadkins4@xxxxxxxxx> wrote:

I am new to SQL 2005 Express. I need to know the procedure for creating one
to many relationships between two or more tables. I don't see any tools with
the Express edition to do this. Thanks for any help.


.