Is it possible to find out which views have been marked for deletion prior to running the purge?

0 Likes

Problem:

Is it possible to find out which views have been marked for deletion prior to running the purge?

Resolution:


  • Product Name: StarTeam
  • Product Version: 2006-2008 R2
  • Product Component: Database
  • Platform/OS Version: All

Yes, the following SQL will return a list of all views that have been deleted and ready to be purged. It also returns a list of the projects that the views belong to, so that you can verify that the correct views have been marked for deletion.

You can run the following code in SQL Query Analyzer or for Oracle use SQLPlus Worksheet.

SELECT syn_View.Name AS View_Name, syn_View.DeletedTime AS Time_Deleted, syn_Project.Name AS Project
FROM syn_View INNER JOIN
syn_Project ON syn_View.ProjectID = syn_Project.ID
WHERE (syn_View.DeletedTime > 0.0)

If you require assistance with running this query please contact Borland Support.


Old KB# 29961
Comment List
Related
Recommended