diagraming databases

Are diagrams passive? What really holds the relationships between the
tables? I have to look at a legacy database in SQL2000 and the diagram does
not seem to match the behavor of the tables.
Diagrams do work if there is a relation established on the tables.
Just check if Primary Key - Foreign Key combination is correctly defined
regards
Chandra
"Rich" wrote:

> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram does
> not seem to match the behavor of the tables.
|||> Are diagrams passive?
Sort of. Possibly that EM tries to "synchronize" a diagram when you open it and you have performed
modifications in the database structure.

> What really holds the relationships between the
> tables?
Defined FOREIGN KEY constraints used in commands such as ALTER TABLE tblref ADD CONSTRAINT col
REFERENCES tblreferenced(col).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:6D4302AE-1F21-41A0-9125-AF8D6085F276@.microsoft.com...
> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram does
> not seem to match the behavor of the tables.

diagraming databases

Are diagrams passive? What really holds the relationships between the
tables? I have to look at a legacy database in SQL2000 and the diagram does
not seem to match the behavor of the tables.Diagrams do work if there is a relation established on the tables.
Just check if Primary Key - Foreign Key combination is correctly defined
regards
Chandra
"Rich" wrote:

> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram do
es
> not seem to match the behavor of the tables.|||> Are diagrams passive?
Sort of. Possibly that EM tries to "synchronize" a diagram when you open it
and you have performed
modifications in the database structure.

> What really holds the relationships between the
> tables?
Defined FOREIGN KEY constraints used in commands such as ALTER TABLE tblref
ADD CONSTRAINT col
REFERENCES tblreferenced(col).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:6D4302AE-1F21-41A0-9125-AF8D6085F276@.microsoft.com...
> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram do
es
> not seem to match the behavor of the tables.

diagraming databases

Are diagrams passive? What really holds the relationships between the
tables? I have to look at a legacy database in SQL2000 and the diagram does
not seem to match the behavor of the tables.Diagrams do work if there is a relation established on the tables.
Just check if Primary Key - Foreign Key combination is correctly defined
regards
Chandra
"Rich" wrote:
> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram does
> not seem to match the behavor of the tables.|||> Are diagrams passive?
Sort of. Possibly that EM tries to "synchronize" a diagram when you open it and you have performed
modifications in the database structure.
> What really holds the relationships between the
> tables?
Defined FOREIGN KEY constraints used in commands such as ALTER TABLE tblref ADD CONSTRAINT col
REFERENCES tblreferenced(col).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:6D4302AE-1F21-41A0-9125-AF8D6085F276@.microsoft.com...
> Are diagrams passive? What really holds the relationships between the
> tables? I have to look at a legacy database in SQL2000 and the diagram does
> not seem to match the behavor of the tables.