MS Project Database relationship

[mba1976]

Hi there,

There are 27 tables in MS Project database, but none of these table have
primary key and foreign key. How can I find the relationship among these
tables?


Thanks,
mba1976

 

[Jack Dahlgren]

Look at the document called Pjdb.htm or projdb.htm. It should be on the
computer you have project installed on, or look at the install disk.
Relationships between the tables are handled by the application, not by the
database, so do not add relationships in the database or project will break.

-Jack Dahlgren

 

[mba1976]

If the Relationships between the tables are handled by the application is
there a way to find out how do they related?


Thanks
mba1976

 

[Jack Dahlgren]

They are related at different times in different ways.
Read the document that I referred you to. It should tell you most of what
you need to know. Just looking at the field names will give you a good idea.

-Jack Dahlgren