how to have the DB diagram

[pv.naveen]

Hi all the SQL wizards there!!!
I have a Data base consisting of 675 tables. There isn't any data base
diagram created and not even any data is present in the system tables
to identify the realtionship betweeen the tables.i am planning to have
the realtionship created betweeen all the tables for easier access. I
couldn't figure out how to do that. Can anyone help me to relate the
tables !!!!!!
The Database in is in SQL server 2000.

[David Portas]

Foreign key constraints are the method used to enforce relationships
between tables. You can create a foreign key like this:

ALTER TABLE table1
ADD CONSTRAINT fk_table1_table2
FOREIGN KEY (col1) REFERENCES table2 (col1) ;

It is also possible to do it through Enterprise Manager although that's
not something you should ever do on a live database - only use EM on a
development system.

For a database with hundreds of tables you will probably want to use a
ER modelling tool to help with the creation of keys. Visio Enterprise
Architect for example.

--
David Portas
SQL Server MVP
--