How to see the relations in the MS Project database tables?

[Ranjanwa]

How to see the relations in the MS Project database tables?´

 

[Jonathan Sofer]

Are you referring to 2003 or 2007? The database structures are different.

In 2003 they are stored in MSP_LINKS.

The schema of the 2003 database is installed on the Project Server front end
automatically. Here is an excerpt from that schema file about link: "Task
links, or dependencies, are stored in the MSP_LINKS table. Each row defines
an association between a predecessor and successor task. Each row defines
only one such association. Multiple links to a given task require a row for
each link."

Hope this helps,
Jonathan Sofer

 

[Jack Dahlgren]

There are not any relations in the MS Project database tables.
All the relationships are handled by the business logic of the application.

For Project 2003 the tables themselves are documented in a file named
pjdb.htm which you can find on your machine.

For Project 2007 you have to go and get the PRoject 2007 SDK which has
information about the database:
http://www.microsoft.com/downloads/...f9-7028-4b30-99a2-18cb1eed1abe&displaylang=en

-Jack Dahlgren

 

[Ranjanwa]

Hi Jonathan,

Thanks for replying.
I am using Project Professinal 2002.

How do I see the relations for MS Project 2002 database tables?

Kindly respond.

Regards,
ranjan

 

[Jonathan Sofer]

Do you have access to the tables? I imagine 2002 is similar to 2003 more so
than 2003 is to 2007. Try looking into the MSP_LINKS table.

Jonathan