Home » SQL & PL/SQL » SQL & PL/SQL » SQL Command to list tables (ORACLE 10i)
SQL Command to list tables [message #356422] Thu, 30 October 2008 12:43 Go to next message
coolguydel
Messages: 2
Registered: October 2008
Junior Member
Hello tehre, can you please tell me a sql command to list all the tables in a particular schema

I am trying this but it doesnt work(shema is the schema name):


select * from schema;

Re: SQL Command to list tables [message #356424 is a reply to message #356422] Thu, 30 October 2008 12:55 Go to previous messageGo to next message
fairgame
Messages: 29
Registered: October 2008
Junior Member
select * from user_tables

select * from tab

Re: SQL Command to list tables [message #356431 is a reply to message #356422] Thu, 30 October 2008 13:06 Go to previous message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select * from dictionary;

This will list you all views you can query to get metadata informations alon with a comment.

Regards
Michel
Previous Topic: Query to retrive the number transactions done in every 1 hour for last one month
Next Topic: What am I doing wrong? Alias ...
Goto Forum:
  


Current Time: Sun Apr 20 13:51:44 CDT 2014

Total time taken to generate the page: 0.07965 seconds