메뉴 닫기

SQL 컬럼명으로 테이블찾기(컬럼명으로 사용중인 테이블 찾기)

SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE ‘%컬럼명%’;

0 0 votes
Article Rating
구독
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x