Posted by DickChristoph on 03/01/06 18:24

Hi Stefano,

Are you sure the tables are truly related?

For example if I script my ShippingQueue Table as Create in the QA it tells
me that ShippingQueue.BoxID References Boxes.BoxID as shown below.

CREATE TABLE [ShippingQueue] (
[Ord] [int] IDENTITY (1, 1) NOT NULL ,
[BoxID] [int] NOT NULL ,
PRIMARY KEY CLUSTERED
(
[Ord]
) ON [PRIMARY] ,
FOREIGN KEY
(
[BoxID]
) REFERENCES [Boxes] (
[BoxID]
)
) ON [PRIMARY]
GO

--
-Dick Christoph
<stemon79@libero.it> wrote in message
news:1141202403.873467.125470@v46g2000cwv.googlegroups.com...
> 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]