SQL 2005 Express Table Relationships

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

Anthony Headley

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL SERVER 2005 Express Create Table Relationship 3
Reaching Access 2003 datas via SQL Server 2005 64 bits 2
Relationships in Access and SQL Server 3
update a SQL 2005 Express table with an MS Access 2003 table 3
use a SQLServer 2005 Express database from Access 2007 1
Using Access 2007 adp project files with SQL Server 2008 Express 3
Cannot connect to SQL Express 2005 1
SQL 2000 + SQL 2005 Express Compatibility 5

Top