컬럼명(필드명)에 특정 문자열 포함하는 테이블 찾기

출처 : https://developerking.tistory.com/10

​

SELECT B.NAME AS TABLE_NM, A.NAME AS COL_NM FROM SYS.ALL_COLUMNS AS A INNER JOIN SYSOBJECTS AS B ON A.OBJECT_ID = B.ID AND B.XTYPE='U' WHERE A.NAME LIKE '찾을 컬럼명%'

출처 : https://blog.naver.com/pjm56k/140058411280

SELECT TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '찾을 컬럼명%'

​