This page contains an archived post to the Java Answers Forum made prior to February 25, 2002.
If you wish to participate in discussions, please visit the new
Artima Forums.
Message:
RE:Searching the whole database
Posted by Kishori Sharan on September 02, 2000 at 1:13 PM
Hi Of course, it is possible to look for an object in a database not knowing the table name, but it is not advisable. If your database is small then you may want to do it. Using your DBMS database catalog you can get the name of all tables on which the current user has the privilege to read the data. Then in a loop keep looking for the object in all table you have in your database. Thanx Kishori
Replies:
|