SOLIDWORKS PDM Tutorial - SQL Query Designer
In this video I will give an introduction to the SQL Server Management Studio (SSMS) Query Designer. This tool can be helpful to create custom queries in the SOLIDWORKS PDM database. Most of the time the “Complete Search” tool that is provided in PDM is adequate for the user’s search needs. However, there are times when specialized information needs to be tweaked from the SQL database. This is when a custom query is needed. Many people prefer a visual tool to help them do something. For developing queries, the Query Designer is that visual tool. Using this tool, I create a query that uses four different tables and variables to return who has deleted files in PDM between certain dates.