📘 Data Dictionary
USER_* and ALL_* views to introspect your own schema.
| Snippet | |
|---|---|
| ☆USER_TABLES — Tables in your schema |
SELECT * FROM USER_TABLES;
|
| ☆USER_TAB_COLUMNS — Columns of your table |
SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'EMPLOYEES';
|
| ☆USER_CONSTRAINTS — Constraints on your table |
SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = 'EMPLOYEES';
|
| ☆ALL_OBJECTS — Objects visible to you |
SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE = 'TRIGGER';
|