Listing All Tables
by Frank Kim on Mar.28, 2008, under MySQL, Oracle
With MySQL listing all the tables in a database is easy enough.
mysql> show tables;
With Oracle it’s a little less straight-forward.
> select table_name from user_tables;
OR
> select * from user_objects where object_type = 'TABLE';
OR
> select table_name from tabs;
OR
> select table_name from all_all_tables;
Related posts:
-
Innovate!
betweenGo is a web solutions provider, specializing in Ruby on Rails and ATG enabled solutions.
If you're interested in becoming a betweenGo client, please contact us.
Please feel free to join the discussion by leaving comments and stay updated by subscribing to the RSS feed.
You can also follow us on Twitter.
You can also subscribe by email by filling the field below:
