Tables Relationship

[Former Member]

Hi guys,

I have a trouble in understanding SBO tables relationship. I can't find the relationship in SQL Server Diagram. Can anyone tell me how to solve this issue?

Thanks

[Former Member · Accepted solution]

Hi,

there are a few relations in SDRQ table

Regards,

Chris

[Former Member]

I haven't seen it in diagram format, but there are a couple of sources that will help you find out about some of the linkages.

The first is the query wizard and query interface in the product itself. If you use this it lists meaningful names against tables, and will automatically generate the correct joins between related tables.

The second is a file called DB_Help.chm. It contains a lot of relevant information about the database tables. I think this is available for download on the service marketplace.

John.

[Former Member]

I have tried that solution, but it's not practical. I believe that the tables relationship is maintained by SBO, not by SQL Server. So, there must be a table or something that keep the relation data in the server...correct me if I'm wrong please. Anyway, thanks for the reply.

Sincerely,

Oki