Re: Oracle and Visio
Date: Wed, 24 Jul 2002 09:47:47 +0100
Message-ID: <3d3e69b3$0$8510$ed9e5944_at_reading.news.pipex.net>
[Quoted] "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
news:3D3D77DF.EB932B77_at_exesolutions.com...
> Charles wrote:
>
> > On Tue, 23 Jul 2002 10:27:30 +0100, "Telemachus"
> > <telemachus_at_ulysseswillreturn.net> wrote:
> >
> > >Yes.
> > >But only if all the pk and RI and fk constraints are in place otherwise
it
> > >can only get what it can see.
> > >
> >
> > I just used Visio on a legacy database. 60 or so tables and no fk/pk
> > defined. All you get is a set of tables, not all that well organized.
> > Not very usefull although it is a place to start.
>
> Why would anyone have a relational database without primary key
constraints?
Because you let the application handle it.
NB Note I am emphatically not recommending this. This is just how developers think so far as I can see.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************Received on Wed Jul 24 2002 - 10:47:47 CEST