cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can change your system assigned username to something more personal in your community settings. X

SQL Database

LV_10442001
4-Participant

SQL Database

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

WhatsApp Image 2022-10-04 at 5.20.32 PM.jpeg

1 ACCEPTED SOLUTION

Accepted Solutions

@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

View solution in original post

5 REPLIES 5

Hi @LV_10442001 

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

PetrH

@LV_10442001 

PTC Knowladge articles describes how to find vault file name

 

cs276507

cs322648  

 

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.

LV_10442001_0-1665129612937.png

 

@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

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."

Top Tags