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

dashang.trivedi · #1 (**permalink**) 05-30-11, 09:35

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...???

healdem · #2 (**permalink**) 05-30-11, 12:22

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

dashang.trivedi · #3 (**permalink**) 05-31-11, 01:37

If i want to get table name of POSTGRES and ORACLE database....any idea???

dashang.trivedi · #4 (**permalink**) 05-31-11, 03:33

i have one idea ..but its time consuming........

Code:

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......?????

Internet Services

Web Development

Digital Marketing

Consumer Tech