How to Query for all User Tables in Oracle Table Name Primary Key Name Indexes Foreign Keys Etc
1, the lookup table for all indexes (including the index name, type, constitute a column): select t. *, i.index_type from user_ind_columns t, user_indexes i where t.index_name = i.index_name and t.table_name





