Difference between MSP_View & MSP_WEB & MSP_* tables

[Gagan Goel]

Can you tell me clear difference between the the three types of tables.

I already have the database schema downloaded but explanation will give me
better understanding.
Regards,

Gagan.

 

[JackD]

The MSP_ tables are where MS project data is stored. If you save a file to
the database it is stored there.
The MSP_Web tables are for project central project server.
The MSP_View tables are for web based views of the project.

Find the following documents on your project CD or a computer where it is
installed

projdb.htm (covers MSP tables)
srvrdb.htm (covers web and view tables)

 

[Gary L. Chefetz \(MVP\)]

The MSP_View tables are Views in the "database" definition of the word. They
can apply to any data access routines regardless of presentation layer.

--

Gary L. Chefetz, MVP
"We wrote the books on Project Server"
http://www.msprojectexperts.com

For Project Server FAQs visit
http://www.projectserverexperts.com

For Project FAQs visit
http://www.mvps.org/project

-