Hi,
I only know these ways : 
           List names of all tables and views
            
After the connection  to Oracle or  Sybase or MySQL  has 
been established, the names of all tables and views that 
belong to the user are displayed.  User can then  select 
one by clicking it (single selection).  
 
The list of tables and  views is retrieved by using  the 
following queries:  
(1) Oracle:
    select table_name from user_tables;
    select view_name from user_views;
(2) Sybase:
    select sysobjects.name 
    from sysusers, sysobjects 
    where sysobjects.uid=sysusers.uid
          and (sysobjects.type='U' or sysobjects.type='V') 
          and sysusers.name='XXX';
(3) MySQL:
    show tables;
Note that MySQL does not support views.

[download]

From : http://www.cslab.uky.edu/~jgao0/mproj/help.txt

I hope this may help you

In reply to Re: if table exists (DBI) by Chief of Chaos
in thread if table exists (DBI) by Bishma

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.