SQL Database

[LV_10442001]

Can help to point to the file name which stores the database table for PDM

[HelesicPetr]

Hi @LV_10442001 

Do you need a file name of Windchill object or do you need the file name of Vault file ?

PetrH

[HelesicPetr]

@LV_10442001 

PTC Knowladge articles describes how to find vault file name

cs276507

cs322648  

PetrH

[LV_10442001]

Hi HelesicPetr,

thanks for the reply. I am looking for a specific table on SQL server which stores the details for the each product created. Please refer image below.

[HelesicPetr · Accepted solution]

@LV_10442001 

It is complicated. Each type of object has own table.

WTPart, EPMDocument, Product, Library, Folders.

There is not just one table that shows you content of specific product.

You need to observe the sql selects in  the articles and you may find the links between tables and other consequences.

for example 

WTPart table contains reference to a context and context is a product or a library

PS: select * from WindchillDB.PDMLinkProduct shows the product information

PetrH

[MikeLockwood]

Another good way to find these (and the relationships) is to create a query builder report with the object type, then select Tools, SQL to see the query.  Note: Have to set preference for Reports to developer in order to see "Tools."