Programming/Database
테이블 및 컬럼 찾기
dev?
2023. 1. 8. 21:13
반응형
1. 테이블 찾기
SELECT * FROM information_schema.tables
WHERE TABLE_NAME = '테이블명';
2. 컬럼명으로 찾기
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME='컬럼명';
https://stratosphere.tistory.com/238
반응형