betweenGo

HOWTO View Tables and Indexes in an Oracle Database

by on Jul.04, 2006, under Oracle

To view the user tables.

select * from tab;

To view the user indexes.

select index_name, table_name from user_indexes;


Share

Related posts:

  1. Listing All Tables
  2. Describing Tables and Constraints in Oracle
  3. HOWTO Really Delete Tables On Oracle 10g
  4. Retrieving the Source from the Database
  5. Best Practices for Creating Tables


Leave a Reply

 

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!