Is it possible to list all projects and views that a file belongs using SQL?
Using the following SQL Query you can capture information on the views and projects a file belongs to based on the filename. In this example a list of view names and the projects they reside in will be returned for the file named "MyFile.txt":
Syn_File.Name, Syn_View.Name as ViewName, Syn_Project.Name as
FROM Syn_File, Syn_View, Syn_Project
WHERE Syn_File.Viewid = Syn_View.ID
AND Syn_View.Projectid = Syn_Project.ID
AND Syn_File.Name = "MyFile.txt";