01-20-2012 07:10 AM
If it table is an sql table then we use Dictionay.But i have table ,i don't know the library or location of table .I know only the name of table.How we can search a table by using base code.
01-20-2012 07:13 AM
What Ksharp referred to was a table of tables, not a sql specific table.
If you are talking about a table that is already in a libname that has already been assigned during a session, then his proposed code should accomplish what you want.
01-20-2012 07:15 AM
As long as you know the name of table , the code you give you all the library name which contains the table name you want to search.
If you want to find all the library which contain a table named 'CLASS' ,then the code below will list all the libraries.