• Lista cu tabelele la care are acces userul curent:

 SELECT TABLE_NAME FROM user_tables; 

• Coloanele unui tabel:

 DESC <table_name>; DESCRIBE emp; 

• Verificarea constrangerilor existente:

SELECT * FROM user_constraints; 
SELECT constraint_name, constraint_type, TABLE_NAME FROM user_constraints WHERE REGEXP_LIKE(TABLE_NAME, 'EMP|DEPT|SALGRADE'); 
SELECT constraint_name, constraint_type, TABLE_NAME FROM user_constraints WHERE TABLE_NAME = 'EMP'; 
 
SELECT * FROM user_cons_columns;

• Formatare afisare

SET LINES 100
SET PAGES 100