Reply to Re: tools for analysis relations

Your name:

Reply:


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.
> >

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация