SQL 2005 Express Table Relationships

  • Thread starter Thread starter Charlie
  • Start date Start date
C

Charlie

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.
 
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.
 
Back
Top