What DB are you using? For Oracle, anyway:
SELECT table_name FROM all_tables; SELECT trigger_name FROM all_triggers; SELECT view_name FROM all_views; ... -Will give you the lists of all tables, triggers, and views respectively in your DB. For the structure of each table, use: DESC <tablename> or SELECT column_name, data_type FROM user_tab_columns WHERE table_name = '<tablename>'; You can also use DESC on the all_whatever views to see what other columns are available for each one. --- Mike Kelley <[EMAIL PROTECTED]> wrote: > I'm looking for some dynamic code that will reveal all libraries, > files, > fields in a DB Does anyone have an example or can you point me in the > right > direction? > > > I know I stumbled across something when installing TC but I can't > find it > now .... > > TIA > > Mike > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
