Results 1 to 4 of 4
  1. #1
    Join Date
    May 2011

    Unanswered: How to get all tables name from database....

    Hello Every one......

    my objective is to fetch all the TABLE NAME from database..i want to fetch the META-DATA of database....
    which is the easiest way to do this???
    Is their any module is available for that...???

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    depednms on the database
    most modern db's store the metadata within the db itself, however you may not have access to that data.

    it may help if you provide the name of the db you are using as each db handles it it its own way
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2011
    If i want to get table name of POSTGRES and ORACLE database....any idea???

  4. #4
    Join Date
    May 2011
    i have one idea ..but its time consuming........

    my @tables = $dbh->tables ( );
    foreach $table (@tables ){
       print "Table Name $table\n";

    but its very time consuming.....

    for example in POSTGRES data base their is one table call pg_class that store all the table name in relname field......but for oracle i dont know......
    is their any module in perl which get all table name list......?????
    Last edited by dashang.trivedi; 05-31-11 at 04:30.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts