We're currently developing on SQL Server 2005 and I have a question about ho
w
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/ne...lcid=u
s).
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
Showing posts with label howsql. Show all posts
Showing posts with label howsql. Show all posts
Wednesday, March 7, 2012
Representation of Relationships in 2005
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
Hi Doug,
This is probably better asked in the SQL Server 2005 newsgroups
(http://communities.microsoft.com/new...r2005&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
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
Hi Doug,
This is probably better asked in the SQL Server 2005 newsgroups
(http://communities.microsoft.com/new...r2005&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
Labels:
creating,
database,
developing,
howsql,
management,
microsoft,
mysql,
oracle,
relationships,
representation,
represents,
server,
sql,
studio
Subscribe to:
Posts (Atom)