ORACLE SQL

해당 컬럼이 존재하는 모든 테이블 찾기

SELECT DISTINCT TABLE_NAME
    FROM ALL_TAB_COLUMNS
    WHERE COLUMN_NAME=`컬럼명`
    ORDER BY TABLE_NAME

제약조건 찾기

select 
    a.table_name
    ,a.constraint_name
    ,b.constraint_type 
    ,a.column_name
    ,a.position   
 from user_cons_columns a
    , user_constraints b
    -- dba_cons_columns a
    -- , dba_constraints b
where a.owner = b.owner
  and a.table_name = '테이블명'
  and a.constraint_name = b.constraint_name

P - Primary Key
R - Foreign Key
U - Unique Key
C - Check, Not Null

테이블 컬럼 COMMENT

SELECT * 
FROM ALL_COL_COMMENTS
WHERE TABLE_NAME = '테이블명';

테이블 구조확인

DESC 테이블명

모든 테이블

select * 
from all_tables
where table_name like '%검색조건%'

order by 조건내에서 일부 자료만 검색

select * from
(select * from [테이블명] [where 조건] [order by 조건 /desc])
where rownum < 100