Posted by stemon79 on 03/01/06 10:40

Hi DickChistoph

if i design a datagram i don't see the relations between tables. WHy?



DickChristoph ha scritto:

> Hi Stefano
>
> You can use the Enterprise Manager and generate a new diagram, Add all the
> tables in the database and it will show the relationships.
>
> Alternatively you can Script Database objects from the Enterprise. Manager.
>
> Select All tables in the Tables node of the database, right click and choose
> "All Tasks", "Generate SQL Script"
>
> Include the option "Script Primary Keys, Foreign Keys, defaults and check
> constraints" and it will include a couple of lines such as :
>
> ALTER TABLE [dbo].[ShippingQueue] ADD
> FOREIGN KEY
> (
> [BoxID]
> ) REFERENCES [dbo].[Boxes] (
> [BoxID]
> )
>
> Which in this case indicates that in the table ShippingQueue, the column
> BoxID references the table Boxes, Column BoxID as a foreign key.
>
> --
> -Dick Christoph
>
> <stemond79@gmail.com> wrote in message
> news:1141032571.895476.126480@e56g2000cwe.googlegroups.com...
> > Are there tools for SQL2k database that take a database return all
> > relations of tables.
> >
> > thanks.
> > Stefano.
> >

• Next in forum: Checking for existing column
• Prev in forum: ANN: 75% off on Database Workbench, only 3 days left!
• Thread view: Re: tools for analysis relations

[Reply to this message]