Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X
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
Hi @LV_10442001
Do you need a file name of Windchill object or do you need the file name of Vault file ?
PetrH
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.
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
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."