SELECT TABLE_NAME FROM USER_TABLES;

SELECT COLUMN_NAME FROM USER_TAB_COLUMNS;

SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS;