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: 65144
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: Partition Question
Next Topic: get ORA-04098 when inserting nextval into sequence nbr using trigger
Goto Forum:
  


Current Time: Sun Aug 20 20:00:04 CDT 2017

Total time taken to generate the page: 0.04794 seconds