Table of Contents

Get Objects From Current Schema

List tables

SELECT TABLE_NAME FROM user_tables;

List indexes

SELECT index_name, TABLE_NAME FROM user_indexes;