If you are looking in Tool #100 Report Builder (Query) then you are not actually seeing a table/file. What you see is actually a list of query definitions - the saved parameters used to create the table. A query definition and a table can sometimes be confused for each other if they have identical names.

As an example, you might have a CDDIVS query definition which you run to create or refresh the CDDIVS table. The practice of giving a table the same name as its query definition is a common one which can be helpful for organization and future research.

When you delete a table via Tool #1980 Library Dashboard it is a stand-alone action which doesn’t have any impact on the query definition which created the table. If you know which query definition created the table, you would use Tool #100 Report Builder (Query) to find and work with the query definition.

In our example, once you have deleted the CDDIVS file via tool #1980, you can expect no longer to see it within that tool. At this point if you were to attempt to set up a table of CDDIVS as a source table in any new query definition, you can also expect to receive the message: File CDDIVS not found in QUERYxx. You will, however, continue to find a query named CDDIVS since you did not delete the query; you have only deleted the table/file which that query creates. The CDDIVS table can be re-created/refreshed at any time by re-running the CDDIVS query definition.