Diagrams a tool anyone can recommend

Hi want to produce a DB diagram on MSQSL 2000.
all I want to do is create links which exist diagrammatically only.
Instead as I UNDERSTAND it the SQL wants to physically create these
constraints on the DB. I DO NOT WANT THIS.
Pls don't answer that I should be using constraints, FK etcs. Not my
call and too late.
Is it possible to simply produce a diagram where I draw links between
fields without effecting underlying DB.
Is there a tool that will do this? Or should I just throw it into word
and make the links myself or use Visio. Preferably would like to
create diagram in MMSQL but which didn't change underlying DB.
Itzik, shalom
I'm afraid you are not able to do that with SQL Server.
Perhaps , there are some third part software to be able to do it for you.
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.co m...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.
|||I generally use Visio for this... But you could use any 3rd party modelling
tool like Erwin, you'd have to set up the PK, FK etc in the logical
model... Just don't push it out to the physical database
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yitzak" <terryshamir@.yahoo.co.uk> wrote in message
news:b73ddf3c.0503290417.8baa183@.posting.google.co m...
> Hi want to produce a DB diagram on MSQSL 2000.
> all I want to do is create links which exist diagrammatically only.
> Instead as I UNDERSTAND it the SQL wants to physically create these
> constraints on the DB. I DO NOT WANT THIS.
> Pls don't answer that I should be using constraints, FK etcs. Not my
> call and too late.
> Is it possible to simply produce a diagram where I draw links between
> fields without effecting underlying DB.
> Is there a tool that will do this? Or should I just throw it into word
> and make the links myself or use Visio. Preferably would like to
> create diagram in MMSQL but which didn't change underlying DB.