We're currently developing on SQL Server 2005 and I have a question about how
SQL Management Studio represents the relationships when creating a diagram.
First off, when creating the relationship, there's no place to designate
whether the relationship is a 1-1 or a 1-M relationship. Secondly, they all
end up being shown as 1-M, with a key on the 1 side and the infinity symbol
on the M side.
I can't find anything in the documentation about how to designate it as a
1-1 relationship instead of a 1-M.
Any ideas?
Thanks for the help.
DougHi Doug,
This is probably better asked in the SQL Server 2005 newsgroups
(http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us).
Have you looked at the topic How to: Create Relationships Between Tables
(Visual Database Tools) in SQL Server Books Online? I just glanced at it,
but it looks like it might answer your question.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Doug" <Doug@.discussions.microsoft.com> wrote in message
news:180D9D97-5E55-42B6-A9BF-986B7FD62E4F@.microsoft.com...
> We're currently developing on SQL Server 2005 and I have a question about
> how
> SQL Management Studio represents the relationships when creating a
> diagram.
> First off, when creating the relationship, there's no place to designate
> whether the relationship is a 1-1 or a 1-M relationship. Secondly, they
> all
> end up being shown as 1-M, with a key on the 1 side and the infinity
> symbol
> on the M side.
> I can't find anything in the documentation about how to designate it as a
> 1-1 relationship instead of a 1-M.
> Any ideas?
> Thanks for the help.
> Doug
Wednesday, March 7, 2012
Representation of Relationships in 2005
Labels:
creating,
database,
developing,
management,
microsoft,
mysql,
oracle,
relationships,
representation,
represents,
server,
sql,
studio
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment