The Artima Developer Community
Sponsored Link

Legacy Java Answers Forum
September 2000

Advertisement

Advertisement

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:

Sponsored Links



Google
  Web Artima.com   
Copyright © 1996-2009 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use - Advertise with Us