Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Which SQL command will display a list of tables in my Oracle database
- Thread starter pace
- Start date
Shockerman
MIS
select *<br>
from user_tables;<br>
<br>
or if you just want to see that table names,<br>
<br>
select table_name<br>
from user_tables;
from user_tables;<br>
<br>
or if you just want to see that table names,<br>
<br>
select table_name<br>
from user_tables;
User_tables will tell you all the tables that are part of your schema (User). If you want to know all the tables in the database try:<br>
<br>
select * from all_tables;<br>
<br>
You may refine that query by adding a where clause:<br>
<br>
select * from all_tables<br>
where owner = 'BBS'; <SUBSTITUTE YOUR USER ID FOR BBS>
<br>
select * from all_tables;<br>
<br>
You may refine that query by adding a where clause:<br>
<br>
select * from all_tables<br>
where owner = 'BBS'; <SUBSTITUTE YOUR USER ID FOR BBS>
- Status
