Skip to main content
L
LV_104420014-Participant
4-Participant
October 4, 2022
Solved

SQL Database

  • October 4, 2022
  • 2 replies
  • 2080 views

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

Best answer by HelesicPetr

@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

2 replies

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
October 5, 2022

Hi @LV_10442001 

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

PetrH

PetrH
HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
October 5, 2022

@LV_10442001 

PTC Knowladge articles describes how to find vault file name

 

cs276507

cs322648  

 

PetrH

PetrH
L
LV_104420014-ParticipantAuthor
4-Participant
October 7, 2022

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

 

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire IIAnswer
22-Sapphire II
October 7, 2022

@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

PetrH
    Terms & ConditionsCookie settingsAccessibility statement