Job Seekers   Employers
dbapool: Authors | Submissions | Contact Us
   Forgot password? | Sign up
  Home   Discussion Forum   Articles   Interview Questions   FAQs   Scripts   Rewards   Analyzer   White Papers   Blog   Certification   Downloads   Tools
 


Frequently Asked Questions

Go Back to FAQ list


How can I find Table, Index and Column which are indexed?
By:- dbapool Editor
 128 Person(s) found this faq useful.


You can use following query to find out Tables, Indexes and Columns. If you want to find Column position then add Column_position column in the query.

SQL> select index_name , table_name , column_name from user_ind_columns order by table_name ;






Did you find this FAQ helpful?

Yes: No:

Name:

Email:

Comments:




Go Back to FAQ list






  About Us Advertise Terms of Use Privacy Newsletters Contact Us    

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads 

Our Premium Sponsor